SQL Server Interview 100

1 MySQL SELECT with LIMIT Easy SQL Server — SELECT basics 2 T-SQL SELECT TOP 3 by salary #1 Hard SQL Server — SELECT basics 3 T-SQL SELECT TOP 4 by salary #2 Medium SQL Server — SELECT basics 4 T-SQL SELECT TOP 5 by salary #3 Easy SQL Server — SELECT basics 5 T-SQL SELECT TOP 6 by salary #4 Medium SQL Server — SELECT basics 6 T-SQL SELECT TOP 7 by salary #5 Hard SQL Server — SELECT basics 7 T-SQL SELECT TOP 3 by salary #6 Medium SQL Server — SELECT basics 8 T-SQL SELECT TOP 4 by salary #7 Easy SQL Server — SELECT basics 9 T-SQL SELECT TOP 5 by salary #8 Medium SQL Server — SELECT basics 10 T-SQL SELECT TOP 6 by salary #9 Hard SQL Server — SELECT basics 11 T-SQL SELECT TOP 7 by salary #10 Medium SQL Server — SELECT basics 12 T-SQL SELECT TOP 3 by salary #11 Easy SQL Server — SELECT basics 13 T-SQL SELECT TOP 4 by salary #12 Medium SQL Server — SELECT basics 14 T-SQL SELECT TOP 5 by salary #13 Hard SQL Server — SELECT basics 15 T-SQL SELECT TOP 6 by salary #14 Medium SQL Server — SELECT basics 16 MySQL SELECT with LIMIT Easy SQL Server — WHERE & filtering 17 T-SQL WHERE salary > 70000 #1 Hard SQL Server — WHERE & filtering 18 T-SQL WHERE salary > 72500 #2 Medium SQL Server — WHERE & filtering 19 T-SQL WHERE salary > 75000 #3 Easy SQL Server — WHERE & filtering 20 T-SQL WHERE salary > 77500 #4 Medium SQL Server — WHERE & filtering 21 T-SQL WHERE salary > 80000 #5 Hard SQL Server — WHERE & filtering 22 T-SQL WHERE salary > 82500 #6 Medium SQL Server — WHERE & filtering 23 T-SQL WHERE salary > 85000 #7 Easy SQL Server — WHERE & filtering 24 T-SQL WHERE salary > 87500 #8 Medium SQL Server — WHERE & filtering 25 T-SQL WHERE salary > 90000 #9 Hard SQL Server — WHERE & filtering 26 T-SQL WHERE salary > 92500 #10 Medium SQL Server — WHERE & filtering 27 T-SQL WHERE salary > 95000 #11 Easy SQL Server — WHERE & filtering 28 T-SQL WHERE salary > 97500 #12 Medium SQL Server — WHERE & filtering 29 T-SQL WHERE salary > 100000 #13 Hard SQL Server — WHERE & filtering 30 T-SQL WHERE salary > 102500 #14 Medium SQL Server — WHERE & filtering

1 MySQL INNER JOIN employees and departments Medium SQL Server — JOINs 2 T-SQL INNER JOIN departments #1 Hard SQL Server — JOINs 3 T-SQL INNER JOIN departments #2 Medium SQL Server — JOINs 4 T-SQL INNER JOIN departments #3 Easy SQL Server — JOINs 5 T-SQL INNER JOIN departments #4 Medium SQL Server — JOINs 6 T-SQL INNER JOIN departments #5 Hard SQL Server — JOINs 7 T-SQL INNER JOIN departments #6 Medium SQL Server — JOINs 8 T-SQL INNER JOIN departments #7 Easy SQL Server — JOINs 9 T-SQL INNER JOIN departments #8 Medium SQL Server — JOINs 10 T-SQL INNER JOIN departments #9 Hard SQL Server — JOINs 11 T-SQL INNER JOIN departments #10 Medium SQL Server — JOINs 12 T-SQL INNER JOIN departments #11 Easy SQL Server — JOINs 13 T-SQL INNER JOIN departments #12 Medium SQL Server — JOINs 14 T-SQL INNER JOIN departments #13 Hard SQL Server — JOINs 15 T-SQL INNER JOIN departments #14 Medium SQL Server — JOINs 16 T-SQL INNER JOIN departments #15 Easy SQL Server — JOINs 17 T-SQL INNER JOIN departments #16 Medium SQL Server — JOINs 18 T-SQL INNER JOIN departments #17 Hard SQL Server — JOINs 19 T-SQL INNER JOIN departments #18 Medium SQL Server — JOINs 20 T-SQL INNER JOIN departments #19 Easy SQL Server — JOINs 21 MySQL SELECT with LIMIT Easy SQL Server — Aggregates & GROUP BY 22 T-SQL AVG salary by department #1 Hard SQL Server — Aggregates & GROUP BY 23 T-SQL AVG salary by department #2 Medium SQL Server — Aggregates & GROUP BY 24 T-SQL AVG salary by department #3 Easy SQL Server — Aggregates & GROUP BY 25 T-SQL AVG salary by department #4 Medium SQL Server — Aggregates & GROUP BY 26 T-SQL AVG salary by department #5 Hard SQL Server — Aggregates & GROUP BY 27 T-SQL AVG salary by department #6 Medium SQL Server — Aggregates & GROUP BY 28 T-SQL AVG salary by department #7 Easy SQL Server — Aggregates & GROUP BY 29 T-SQL AVG salary by department #8 Medium SQL Server — Aggregates & GROUP BY 30 T-SQL AVG salary by department #9 Hard SQL Server — Aggregates & GROUP BY 31 T-SQL AVG salary by department #10 Medium SQL Server — Aggregates & GROUP BY 32 T-SQL AVG salary by department #11 Easy SQL Server — Aggregates & GROUP BY 33 T-SQL AVG salary by department #12 Medium SQL Server — Aggregates & GROUP BY 34 T-SQL AVG salary by department #13 Hard SQL Server — Aggregates & GROUP BY 35 T-SQL AVG salary by department #14 Medium SQL Server — Aggregates & GROUP BY

1 MySQL SELECT with LIMIT Easy SQL Server — CTEs 2 T-SQL CTE ranked earners #1 Hard SQL Server — CTEs 3 T-SQL CTE ranked earners #2 Medium SQL Server — CTEs 4 T-SQL CTE ranked earners #3 Easy SQL Server — CTEs 5 T-SQL CTE ranked earners #4 Medium SQL Server — CTEs 6 T-SQL CTE ranked earners #5 Hard SQL Server — CTEs 7 T-SQL CTE ranked earners #6 Medium SQL Server — CTEs 8 T-SQL CTE ranked earners #7 Easy SQL Server — CTEs 9 T-SQL CTE ranked earners #8 Medium SQL Server — CTEs 10 T-SQL CTE ranked earners #9 Hard SQL Server — CTEs 11 T-SQL CTE ranked earners #10 Medium SQL Server — CTEs 12 T-SQL CTE ranked earners #11 Easy SQL Server — CTEs 13 T-SQL CTE ranked earners #12 Medium SQL Server — CTEs 14 T-SQL CTE ranked earners #13 Hard SQL Server — CTEs 15 T-SQL CTE ranked earners #14 Medium SQL Server — CTEs 16 MySQL SELECT with LIMIT Easy SQL Server — Window functions 17 T-SQL PARTITION BY dept #1 Hard SQL Server — Window functions 18 T-SQL PARTITION BY dept #2 Medium SQL Server — Window functions 19 T-SQL PARTITION BY dept #3 Easy SQL Server — Window functions 20 T-SQL PARTITION BY dept #4 Medium SQL Server — Window functions 21 T-SQL PARTITION BY dept #5 Hard SQL Server — Window functions 22 T-SQL PARTITION BY dept #6 Medium SQL Server — Window functions 23 T-SQL PARTITION BY dept #7 Easy SQL Server — Window functions 24 T-SQL PARTITION BY dept #8 Medium SQL Server — Window functions 25 T-SQL PARTITION BY dept #9 Hard SQL Server — Window functions 26 T-SQL PARTITION BY dept #10 Medium SQL Server — Window functions 27 T-SQL PARTITION BY dept #11 Easy SQL Server — Window functions 28 T-SQL PARTITION BY dept #12 Medium SQL Server — Window functions 29 T-SQL PARTITION BY dept #13 Hard SQL Server — Window functions 30 T-SQL PARTITION BY dept #14 Medium SQL Server — Window functions 31 MySQL SELECT with LIMIT Easy SQL Server — T-SQL procedures 32 T-SQL stored procedure raise #1 Hard SQL Server — T-SQL procedures 33 T-SQL stored procedure raise #2 Medium SQL Server — T-SQL procedures 34 T-SQL stored procedure raise #3 Easy SQL Server — T-SQL procedures 35 T-SQL stored procedure raise #4 Medium SQL Server — T-SQL procedures