TASK 6 Multi-table queries with JOINs

Question 1

Find the domestic and international sales for each movie

Answer 1

SELECT title, domestic_sales, international_sales
FROM movies
JOIN boxoffice
ON movies.id = boxoffice.movie_id;

Question 2

Show the sales numbers for each movie that did better internationally rather than domestically

Answer 2

SELECT title, domestic_sales, international_sales
FROM movies
JOIN boxoffice
ON movies.id = boxoffice.movie_id
WHERE international_sales > domestic_sales;

Question 3

List all the movies by their ratings in descending order

Answer 3

SELECT title, rating
FROM movies
JOIN boxoffice
ON movies.id = boxoffice.movie_id
ORDER BY rating DESC;