Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT(a.name,' ', a.surname) as "Deluxe drivers", m.producer, m.model
- from employer a
- INNER JOIN Driver s on s.iddriver=a.idemployer
- INNER JOIN Taxi t ON t.idtaxi=s.idtaxi
- INNER JOIN Model m ON m.idmodelcar=t.idmodelcar
- WHERE m.producer IN ('Audi','Skoda','Honda','Hyundai') AND m.year>2010
- GROUP BY a.name, a.surname, m.producer, m.model
- ORDER BY 2,3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement