SQL Practice Queries

0 / 9 solved

Question Tags Difficulty Success

1. Departments with 100+ Employees

Basics

Medium 52%

2. Where To Start The Query

problem-solvingquery-design +1

Medium —

3. Month Over Month

lagwindow-functions +1

Medium —

4. Keep The Newest Signup

deduplicationrow-number +1

Medium —

5. One Row Per User

distinct-ontop-n-per-group +1

Medium —

6. The Last Day Is Missing

date-rangessargable-predicates +1

Medium —

7. Managers of High-Budget Departments

Basics

Hard 60%

8. Employees in Both Departments

Basics

Hard 27%

9. Which Ones Use The Index

indexesconcatenated-index +1

Hard —

Up next

9 of 9 questions here are still unsolved.

Next module SQL Window Functions & Advanced