What is the order of execution?

What is the order of execution of below sql??

select, from, join, where, group by, having, order by

When a query is submitted to the database, it is executed in the following order:

1.FROM clause

2.WHERE clause

3.GROUP BY clause

4.HAVING clause

5.SELECT clause

6.ORDER BY clause

So why is it important to understand this?

When a query is executed,

First all the tables and their join conditions are executed filtering out invalid references between them.

Then the WHERE clause is applied which again filters the records based on the condition given.

Now you have handful of records which are GROUP-ed

And HAVING clause is applied on the result.

As soon as it is completed, the columns mentioned are selected from the corresponding tables.

And finally sorted using ORDER BY clause.

So when a query is written it should be verified based on this order, otherwise it will lead wrong result sets.