Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT CONCAT(a.name,' ', a.surname) as "Deluxe drivers", m.producer, m.model
  2. from employer a
  3. INNER JOIN Driver s on s.iddriver=a.idemployer
  4. INNER JOIN Taxi t ON t.idtaxi=s.idtaxi
  5. INNER JOIN Model m ON m.idmodelcar=t.idmodelcar
  6. WHERE m.producer IN ('Audi','Skoda','Honda','Hyundai') AND m.year>2010
  7. GROUP BY a.name, a.surname, m.producer, m.model
  8. ORDER BY 2,3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement