Practice / Spark SQL Challenges

⚡ Spark SQL Practice Challenges

The SQL patterns that come up in every Spark and data engineering interview — deduplication with window functions, running totals, month-over-month deltas, and top-N per group.

Note: challenges execute on an in-browser SQLite engine, so they use ANSI SQL that runs identically in Spark SQL.

🌱
Novice
0 XP · 50 to Apprentice
🔥 0 day streak

Deduplicate values

Easy

Return the list of distinct countries that appear in the customers table.

Loading SQL engine (runs 100% in your browser)…
⌘/Ctrl + Enter to run