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
EasyReturn the list of distinct countries that appear in the customers table.
Loading SQL engine (runs 100% in your browser)…
⌘/Ctrl + Enter to run