SQL Server — Subqueries

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