Queries

[WITH name AS (query), ...]
SELECT [DISTINCT] expression [AS alias], ...
[FROM source [JOIN source ON condition] ...]
[WHERE condition]
[GROUP BY expression, ...]
[HAVING condition]
[ORDER BY expression [ASC | DESC] [NULLS FIRST | NULLS LAST], ...]
[LIMIT count [OFFSET count]]

SELECT i_item_sk AS item_key, i_category AS category,
       CAST(i_current_price AS DOUBLE) AS price
FROM demo.tpcds.item
ORDER BY item_key
LIMIT 10;

SELECT i_item_sk, i_category, i_current_price
FROM demo.tpcds.item
WHERE i_category IS NOT NULL
  AND i_current_price BETWEEN 10 AND 30
ORDER BY i_current_price DESC, i_item_sk
LIMIT 20;

SELECT DISTINCT ca_state
FROM demo.tpcds.customer_address
WHERE ca_state IS NOT NULL
ORDER BY ca_state
LIMIT 20;

SELECT i_item_sk, i_current_price
FROM demo.tpcds.item
ORDER BY i_current_price DESC NULLS LAST, i_item_sk
LIMIT 5 OFFSET 5;