SELECT <column> <name>, <column> <name>, ... FROM <table> WHERE <condition> GROUP BY <column> HAVING <condition> ORDER BY <column> <ASC | DESC>, <column2> <ASC | DESC> ... LIMIT <offset> <number>;