Coding Challenges

○

SQL: Department Top Earner

SQL — Window Functions SQL RANK PARTITION BY

Medium

10,462

Submissions

45.28%

Acceptance

○

SQL: Rising Temperature

SQL — Self Join SQL Self Join DATE

Medium

10,889

Submissions

43.28%

Acceptance

○

SQL: Rank Scores

SQL — Window Functions SQL DENSE_RANK

Medium

12,162

Submissions

41.73%

Acceptance

○

SQL: Consecutive Numbers

SQL — Self Join SQL Self Join Consecutive

Medium

4,775

Submissions

38.08%

Acceptance

○

SQL: Employees Earning More Than Manager

SQL — Self Join SQL Self Join

Medium

4,307

Submissions

40.49%

Acceptance

○

SQL: Nth Highest Salary

SQL — Subqueries SQL Subquery Variable

Medium

4,789

Submissions

41.93%

Acceptance

○

SQL: Department Salary Budget

SQL — Aggregation SQL SUM GROUP BY

Medium

8,263

Submissions

58.73%

Acceptance

○

SQL: Pivot Employee Data

SQL — Advanced SQL CASE WHEN Pivot

Medium

3,423

Submissions

53.72%

Acceptance

○

SQL: Running Total

SQL — Window Functions SQL Running Total OVER

Medium

11,005

Submissions

48.07%

Acceptance

○

SQL: Delete Duplicates

SQL — DML SQL DELETE Subquery

Medium

7,333

Submissions

43.56%

Acceptance

○

SQL: Combine Two Tables

SQL — Joins SQL LEFT JOIN

Medium

10,920

Submissions

60.55%

Acceptance

○

SQL: Exchange Seats

SQL — Advanced SQL CASE WHEN MOD

Medium

2,383

Submissions

54.90%

Acceptance

○

SQL: Human Traffic of Stadium

SQL — Advanced SQL Self Join Consecutive

Medium

5,801

Submissions

50.76%

Acceptance

○

SQL: Median Employee Salary

SQL — Window Functions SQL ROW_NUMBER Median

Medium

4,431

Submissions

57.27%

Acceptance

○

SQL: Active Users

SQL — Advanced SQL DATE Window Functions

Medium

13,067

Submissions

50.55%

Acceptance

○

SQL: Tree Node

SQL — Subqueries SQL CASE Subquery

Medium

5,378

Submissions

45.48%

Acceptance

○

SQL: Monthly Revenue Growth

SQL — Window Functions SQL LAG Growth

Medium

1,645

Submissions

53.34%

Acceptance

○

SQL: Find Peak Hours

SQL — Subqueries SQL AVG Subquery

Medium

7,621

Submissions

59.55%

Acceptance

○

SQL: Employee Hierarchy

SQL — Advanced SQL CTE Recursion

Medium

10,619

Submissions

35.05%

Acceptance

○

SQL: Salary Percentile

SQL — Window Functions SQL PERCENT_RANK

Medium

7,658

Submissions

47.36%

Acceptance