Informix CGI SQL

SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY ...