<query expression>
[ ORDER BY <sort specification comma list> ]
{ <query term> [ <table operator> [ <qualifier> ] <query term> ]...
<query specification>
| <subquery>
SELECT [ <qualifier> ] <select list> [ { TO | INTO } <variable comma list> ]
FROM <extended table specification comma list>
[ WHERE <search condition> ]
[ GROUP BY <path expression comma list> ]
[ HAVING <search condition> ]
[ <using index clause> ]
(<query statement>)
UNION
| { DIFFERENCE | EXCEPT }
| INTERSECTION
ALL
| DISTINCT
| UNIQUE
*
| <aliased expression comma list>
| <aliased counter expression comma list>
counter expression : INCR(path expression)
<aliased expression> [ { , <aliased expression> }... ]
<expression> [ [ AS ] <alias name> ]
<sort specification> [ { , <sort specification> }... ]
{ <path expression> | <unsigned integer literal> | <alias> } [ ASC | DESC ]
USING INDEX { <index name comma list> | NONE }
SELECT * FROM resort;
SELECT lodging FROM location WHERE country = 'Jamaica';
SELECT country, AVG(cost) FROM hotel
WHERE allows_children = 'yes' AND
number_of_pools > 0
GROUP BY country HAVING AVG(cost) <= $150.00;