SQL Server — Aggregates & GROUP BY

1 MySQL SELECT with LIMIT Easy 2 T-SQL AVG salary by department #1 Hard 3 T-SQL AVG salary by department #2 Medium 4 T-SQL AVG salary by department #3 Easy 5 T-SQL AVG salary by department #4 Medium 6 T-SQL AVG salary by department #5 Hard 7 T-SQL AVG salary by department #6 Medium 8 T-SQL AVG salary by department #7 Easy 9 T-SQL AVG salary by department #8 Medium 10 T-SQL AVG salary by department #9 Hard 11 T-SQL AVG salary by department #10 Medium 12 T-SQL AVG salary by department #11 Easy 13 T-SQL AVG salary by department #12 Medium 14 T-SQL AVG salary by department #13 Hard 15 T-SQL AVG salary by department #14 Medium 16 T-SQL AVG salary by department #15 Easy 17 T-SQL AVG salary by department #16 Medium 18 T-SQL AVG salary by department #17 Hard 19 T-SQL AVG salary by department #18 Medium 20 T-SQL AVG salary by department #19 Easy 21 T-SQL AVG salary by department #20 Medium 22 T-SQL AVG salary by department #21 Hard 23 T-SQL AVG salary by department #22 Medium 24 T-SQL AVG salary by department #23 Easy 25 T-SQL AVG salary by department #24 Medium 26 T-SQL AVG salary by department #25 Hard 27 T-SQL AVG salary by department #26 Medium 28 T-SQL AVG salary by department #27 Easy 29 T-SQL AVG salary by department #28 Medium 30 T-SQL AVG salary by department #29 Hard 31 T-SQL AVG salary by department #30 Medium 32 T-SQL AVG salary by department #31 Easy 33 T-SQL AVG salary by department #32 Medium 34 T-SQL AVG salary by department #33 Hard 35 T-SQL AVG salary by department #34 Medium 36 T-SQL AVG salary by department #35 Easy 37 T-SQL AVG salary by department #36 Medium 38 T-SQL AVG salary by department #37 Hard 39 T-SQL AVG salary by department #38 Medium 40 T-SQL AVG salary by department #39 Easy 41 T-SQL AVG salary by department #40 Medium 42 T-SQL AVG salary by department #41 Hard 43 T-SQL AVG salary by department #42 Medium 44 T-SQL AVG salary by department #43 Easy 45 T-SQL AVG salary by department #44 Medium 46 T-SQL AVG salary by department #45 Hard 47 T-SQL AVG salary by department #46 Medium 48 T-SQL AVG salary by department #47 Easy 49 T-SQL AVG salary by department #48 Medium 50 T-SQL AVG salary by department #49 Hard