1
2
3
4
5
6
7
8
9

SELECT DISTINCT column, AGG_FUNC(*column_or_expression*), … 
FROM mytable 
JOIN another_table ON mytable.column = another_table.column
WHERE *constraint_expression* 
GROUP BY column 
HAVING *constraint_expression* 
ORDER BY *column* ASC/DESC 
LIMIT *count* 
OFFSET *COUNT*;