Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT m.id,title, SUM(number_of_tickets) AS 'sold_tickets' FROM movies m ,reservations r WHERE m.id = r.movie_id
- GROUP BY m.id,m.title ORDER BY SUM(number_of_tickets) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement