mobile typing isn't scored — practice only

SELECT d.name AS Department, e.name AS Employee, e.salary AS Salary

SQL · leetcode · type the snippet below to practice

wpm0

acc100%

time–

def fib(n): a, b = 0, 1 for _ in range(n): a, b = b, a + b return a

tab indent · shift+tab outdent · ctrl+⌫ delete word · esc restart ·

about this snippet

This is the deptthree snippet in SQL — a classic LeetCode interview problem. Type it through to build the muscle memory you need to write it under interview pressure. DeveloperType scores you on net WPM and accuracy and only counts runs above 95% accuracy on the leaderboard, so practice rewards precision, not speed alone.

view source (10 lines)

SELECT d.name AS Department, e.name AS Employee, e.salary AS Salary
FROM Employee e
JOIN Department d ON d.id = e.departmentId
WHERE 3 > (
    SELECT COUNT(DISTINCT e2.salary)
    FROM Employee e2
    WHERE e2.salary > e.salary
      AND e2.departmentId = e.departmentId
);

more SQL snippets:

browse all SQL snippets →