-- 1. Select the code which uses an outer join correctly. -- 3. Select out of following the code which uses a JOIN to show a list of all the departments and number of employed teachers SELECT ...

FROM stops a JOIN route z ON a.id=z.stop JOIN route y ON y.num = z.num JOIN stops b ON y.stop=b.id WHERE a.name='Craiglockhart' AND b.name ='Haymarket' -- 2. Select the code that shows the stops that ...