What will be execution sequence of from, select, where and group by in SQL engine ?

See more:

SQL

Oracle

database

data-analysis

Suppose we have a requirement to fetch a record on basis of a condition.

select records from the table on the basis of where clause and sort them by group by clause.

Normally we used to code it like

select first_name,salary
from table1
where salary>10000 --optional
group by first_name,salary;

What I have tried:

select cool1,col2
from table
where condition --optional
group by col1,col2;