Write down the general syntax for a SELECT statements covering all the options. | SQL DBA

Here's the basic syntax: 
SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC] ]