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;

Last updated