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