Order of execution of a Query
SQL Lesson 12
Orden de ejecución en una consulta:
FROM y JOINs
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
ORDER BY
LIMIT y OFFSET
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