Advertisement
Aliendreamer

8th problem from 3.06 sql exam

Jun 13th, 2018
366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT m.Model, m.Seats, v.Mileage
  2. FROM Vehicles AS v
  3. INNER JOIN Models AS m ON m.Id = v.ModelId
  4. WHERE v.Id != ALL (
  5.         SELECT VehicleId FROM Orders WHERE ReturnDate IS NULL
  6. )
  7. ORDER BY v.Mileage ASC, m.Seats DESC, v.ModelId ASC, m.Model ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement