The order of execution in SQL for a query is generally as follows:

1. FROM clause: This specifies the tables from which data will be retrieved.

2. WHERE clause: This filters rows based on specified conditions.

3. GROUP BY clause: This groups rows that have the same values into summary rows.

4. HAVING clause: This filters group rows based on specified conditions.

5. SELECT clause: This retrieves the columns specified.

6. ORDER BY clause: This sorts the result set based on specified columns.

7. LIMIT/OFFSET clause: This limits the number of rows returned and optionally skips a specified number of rows.

It's important to note that not all queries include every clause, and the order may vary slightly depending on the specific query being executed. Additionally, the SQL query optimizer may choose to execute the query in a different order for optimization purposes. For more check out the online SQL tutorial and data science course!