Logical Execution Order of SQL SELECT's clauses
See full Playlist at • SQL Query Foundations
00:00 Introduction
00:49 Alias causes error
02:21 Logical Execution Order
04:24 Sample Data
05:02 Example 1: Alias works fine
06:23 RULE- Alias in SELECT
06:42 Example 2: Logical Phases in detail
06:49 FROM & WHERE
07:27 GROUP BY & its Implications
08:05 RULE for GROUP BY
08:59 HAVING
09:29 SELECT, ORDER BY
10:05 RULE for All-At-Once
10:47 All-At-Once and Divide-by-zero
11:51 Recap - 5 Takeaways
13:57 The End