Data and ML 0/68

Data and ML

SQL

Selecting, grouping, joins, subqueries and window functions, then whole queries written against a schema. Data and quant roles often include a SQL screen.

0 / 37 solved

Questions

0/37 solved
Question Module Tags Difficulty Success
1. Unionized SQL Fundamentals
SQL
Easy 76%
2. Null fallback helper SQL Fundamentals
Basics
Easy 60%
3. SQL Filters SQL Fundamentals
Basics
Medium 84%
4. Superkey Existence SQL Fundamentals
Basics
Medium 90%
5. GROUP BY Validation SQL Fundamentals
Basics
Medium 67%
6. Two Ways To Count SQL Fundamentals
null-semanticsaggregates +1
Medium 60%
7. The Alias Is Not There Yet SQL Fundamentals
clause-orderhaving +1
Medium —
8. HAVING Clause Validity SQL Fundamentals
Basics
Medium 16%
9. NULL Handling in WHERE SQL Fundamentals
Basics
Medium 85%
10. MAX in WHERE Clause SQL Fundamentals
Basics
Medium 75%
11. Filtered Inside The Group SQL Fundamentals
filter-clausehaving +1
Medium —
12. Counting The Paid Ones SQL Fundamentals
conditional-aggregationnull-semantics +1
Medium —
13. Multiply By Loops SQL Fundamentals
explainquery-plans +1
Medium —
14. SQL Self Join SQL Joins & Subqueries
Basics
Medium 69%
15. Outer Join Equivalence SQL Joins & Subqueries
Basics
Medium 68%
16. Where Turns It Inner SQL Joins & Subqueries
outer-joinsnull-semantics +1
Medium —
17. Rewriting The Scalar Subquery SQL Joins & Subqueries
correlated-subqueryouter-joins +1
Medium —
18. SQL Correlated Subquery SQL Joins & Subqueries
Basics
Medium 81%
19. Projection After Join Size SQL Joins & Subqueries
Basics
Medium 67%
20. Nobody Comes Back SQL Joins & Subqueries
not-innull-semantics +1
Medium —
21. The Shipping Doubled SQL Joins & Subqueries
join-fan-outaggregates +1
Medium —
22. Ten Rows Versus Hundred SQL Joins & Subqueries
query-planshash-join +1
Hard —
23. Third Or Second Place SQL Window Functions & Advanced
ranking-functionspeers +1
Medium —
24. SQL Window Function Ordering SQL Window Functions & Advanced
Basics
Medium 100%
25. Top Three Per Customer SQL Window Functions & Advanced
window-functionsclause-order +1
Medium —
26. Last Value Is Not Last SQL Window Functions & Advanced
frame-clausefirst-value +1
Medium —
27. One Level At A Time SQL Window Functions & Advanced
recursive-ctehierarchies +1
Medium —
28. The Running Total Jumps SQL Window Functions & Advanced
frame-clauserows-vs-range +1
Hard —
29. Departments with 100+ Employees SQL Practice Queries
Basics
Medium 44%
30. Where To Start The Query SQL Practice Queries
problem-solvingquery-design +1
Medium —
31. Month Over Month SQL Practice Queries
lagwindow-functions +1
Medium —
32. Keep The Newest Signup SQL Practice Queries
deduplicationrow-number +1
Medium —
33. One Row Per User SQL Practice Queries
distinct-ontop-n-per-group +1
Medium —
34. The Last Day Is Missing SQL Practice Queries
date-rangessargable-predicates +1
Medium —
35. Managers of High-Budget Departments SQL Practice Queries
Basics
Hard 60%
36. Employees in Both Departments SQL Practice Queries
Basics
Hard 27%
37. Which Ones Use The Index SQL Practice Queries
indexesconcatenated-index +1
Hard —