I'm writing this post because developers often get confused about the SQL clauses execution order. The most important and basic SQL clauses are
- SELECT
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- SELECT
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- FROM
- WHERE
- GROUP BY
- HAVING
- SELECT
- ORDER BY