Tutorial 4, page 16 Context: jobsEngine: oracle

Write a query which shows which employee has had the most jobs with the company. There may be multiple employees with the biggest job count. Show the surname,forename, and the job count in your answer. You will have to GROUP BY two columns (e.g. GROUP BY x,y).

Active SQL index Previous Question             

SQL To Be Executed