SQL Tutorials

Tutorial 5, page 8

Context: jobs

Engine: oracle

Write a query which lists all empno values against the NAME of the courses they did. If an empno has not been on any courses list the empno against a blank course. Hint: you have to handle two joins which involve NULL; empcourse and course.

Active SQL index

Previous Question

Next Question

SQL To Be Executed