Query logic flow

(7) select (8) distinct

(10) <TOP> <select list>

(1) FROM <left table>

(3) <join type> JOIN <right table>

(2) ON <join condition>

(4) WHERE <where condition>

(5) GROUP BY <group list>

(6) HAVING <having condition>

(9) ORDER BY <order list>

1. from table
2. join condition
3. join
4. where conditions
5. group by
6. having conditions
7. select
8. distinct on the select
9. order by
10. top x rows (of the select)