Optional select functions
Several optional clauses can be defined in a select statement as WHERE , HAVING for pre- and post selection, GROUP_BY for aggregation and ORDER_BY for ordering in a special way.
Definition:
sel_extensions := from_spec | where_spec | having_spec | group_spec | order_spec