Re:Easy Steps to a Complete Understanding of SQL
by lukaseder on Tuesday September 03, 2013 @10:56AM
(#6321313)
(I had to correct myself)
SELECT is evaluated after GROUP BY, at least in most databases that implement SQL correctly. SQL Server's documentation nicely explains this:
http://technet.microsoft.com/en-us/library/ms189499.aspx
Skip to "Logical Processing Order of the SELECT statement".
MySQL, PostgreSQL, and SQLite behave differently, though!
FROM, JOIN, WHERE, SELECT, GROUP BY, HAVING, DISTINCT, UNION, ORDER BY, LIMIT.
The author has SELECT after the GROUP BY and HAVING, which doesn't make sense because GROUP BY is aware of expressions in the SELECT statement. Grouping and filtering happens after selection.