Aliendreamer

10 problem form 3.01.2018 exam sql

Jun 16th, 2018
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT m.Manufacturer,m.Model,COUNT(o.VehicleId) AS 'TimesOrdered'
  2.  FROM Models AS m
  3. LEFT JOIN Vehicles AS v ON v.ModelId=m.Id
  4. FULL JOIN Orders AS o ON v.Id=o.VehicleId
  5. GROUP BY m.Manufacturer,m.Model
  6. ORDER BY TimesOrdered DESC,m.Manufacturer DESC,m.Model ASC
Advertisement
Add Comment
Please, Sign In to add comment