12_order_of_execution_of_a_query.sql

-- 1. Find the number of movies each director has directed.

  SELECT director,
         COUNT(title) AS number_of_movies
    FROM movies
GROUP BY director;

-- 2. Find the total domestic and international sales that can be attributed
-- to each director.

  SELECT director,
         SUM(domestic_sales + international_sales) AS total_sales
    FROM movies
    JOIN boxoffice ON movies.id = boxoffice.movie_id
GROUP BY director;