WITH

UNION & UNION ALL

ROWNUM

NVL, NULLIF, COALESCE

CASE WHEN - THEN

BETWEEN A AND B

EXTRACT