Querying Data with Databricks SQL

Write SELECT queries with filtering, sorting, and aliasing in Databricks SQL.

Perform INNER, LEFT, RIGHT, and FULL OUTER joins between two or more tables.

Use GROUP BY with aggregate functions (COUNT, SUM, AVG, MIN, MAX) to summarize data.

Use CASE expressions to implement conditional logic in queries.

Write subqueries and common table expressions (CTEs) to structure complex queries.

Apply window functions (ROW_NUMBER, RANK, LAG, LEAD) for row-level analytics.