Order of Execution

				
					SELECT * 
FROM (
      SELECT * 
      FROM employees
      LIMIT 7
) x
OFFSET 6;

				
					SELECT released, AVG(rating)
FROM films
WHERE AVG(rating) > 8
GROUP BY released;

				
					SELECT released, AVG(rating) AS avg_rating
FROM films
GROUP BY released
HAVING AVG(rating) > avg_rating;

				
					SELECT released, AVG(rating) AS avg_rating
FROM films
GROUP BY released
HAVING AVG(rating) > 8;

Back to

Back to