Write the order of execution of all the SQL clauses and statements
Step 1: Getting Data (From, Join) FROM citizen. ... Step 2: Row Filter (Where) After getting qualified rows, it is passed on to the Where clause. ... Step 3: Grouping (Group by) ... Step 4: Group Filter (Having) ... Step 5: Return Expressions (Select) ... Step 6: Order (Order by) and Paging (Limit / Offs