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
Login Details
Email Address
Password
Register for an account
Main Index Page
Author Home Page
Forgotten your password
About ActiveSQL
Tutorial Documents
Database Notes
Online Notes
Reference Pages
Tutorial Activities
Online SQL
Online Quiz
Discussion Forum
Future Stuff
Online Relational Algebra
News