Order of execution of a Query

SQL Lesson 12

Orden de ejecución en una consulta:

1. FROM y JOINs

2. WHERE

3. GROUP BY

4. HAVING

5. SELECT

6. DISTINCT

7. ORDER BY

8. LIMIT y OFFSET

---

1. Encuentra el número de películas que ha dirigido cada director.

SELECT COUNT(director),director 
FROM movies
GROUP BY director;

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