• Overview
• Hints
• WITH clause
• SELECT & WHERE
• SELECT DISTINCT
• Windowing TVF
• Window Aggregation
• Group Aggregation
• Over Aggregation
• Joins
• Window JOIN
• Set Operations
• ORDER BY clause
• LIMIT clause
• Top-N
• Window Top-N
• Deduplication
• Window Deduplication
• Pattern Recognition