SQL Tutorials

Tutorial 5, page 4

Context: jobs

Engine: oracle

create a statement which combines the views from questions 2 and 3 together to show how many jobs and how many courses each empno has been on. You SHOULD NOT create the views again as part of the answer, just access them with the same name used to create them in the previous questions. If the employee has been on 0 courses then the total no of courses for that employee should be blank (null). Hint: use OUTER JOIN.

Active SQL index

Previous Question

Next Question

SQL To Be Executed