select
distinct
From left_table
<join> right_table
On <join_condition>
Group by <group_list>
with cube|rollup
Having <having_condition>
Order by <orderby_list>
Limit <limit_number>
select
distinct
From left_table
<join> right_table
On <join_condition>
Group by <group_list>
with cube|rollup
Having <having_condition>
Order by <orderby_list>
Limit <limit_number>