News for hackers. Stuff that matters.
Re:Show HN: Select Star SQL, an interactive SQL book by piaste on Tuesday September 04, 2018 @12:30PM (#17910262)
More generally, statements should appear in the same order as they are executed, as far as this is possible.

This nullifies some other common sources of confusion, such as which statements are executed before a GROUP BY and which ones after (and why HAVING exists as a keyword). It's also similar to how CTE syntax is generally much more readable than subqueries.

Re:Show HN: Select Star SQL, an interactive SQL book by hesk on Wednesday September 05, 2018 @05:03PM (#17921900)
The order of clauses in a SQL statement should have no relation on the order of execution because SQL is a declarative query language. The query specifies what the user wants and not how the system should compute the answer.

This declarative property also provides a (somewhat weak) motivation of why SELECT should come first. Precisely because it answers part of the WHAT, i.e., the schema of the result.