In general (PostgreSQL like-flavor), we can summarize the SQL coding order as:

1. SELECT

2. DISTINCT

3. FROM

4. JOIN

5. WHERE

6. GROUP BY

7. HAVING

8. ORDER BY

9. LIMIT

Whereas, its execution order will be:

1. FROM

2. JOIN

3. WHERE

4. GROUP BY

5. HAVING

6. SELECT

7. DISTINCT

8. ORDER BY

9. LIMIT