SQL Server — Window functions

51 T-SQL PARTITION BY dept #50 Medium 52 T-SQL PARTITION BY dept #51 Easy 53 T-SQL PARTITION BY dept #52 Medium 54 T-SQL PARTITION BY dept #53 Hard 55 T-SQL PARTITION BY dept #54 Medium 56 T-SQL PARTITION BY dept #55 Easy 57 T-SQL PARTITION BY dept #56 Medium 58 T-SQL PARTITION BY dept #57 Hard 59 T-SQL PARTITION BY dept #58 Medium 60 T-SQL PARTITION BY dept #59 Easy 61 T-SQL PARTITION BY dept #60 Medium 62 T-SQL PARTITION BY dept #61 Hard 63 T-SQL PARTITION BY dept #62 Medium 64 T-SQL PARTITION BY dept #63 Easy 65 T-SQL PARTITION BY dept #64 Medium 66 T-SQL PARTITION BY dept #65 Hard 67 T-SQL PARTITION BY dept #66 Medium 68 T-SQL PARTITION BY dept #67 Easy 69 T-SQL PARTITION BY dept #68 Medium 70 T-SQL PARTITION BY dept #69 Hard 71 T-SQL PARTITION BY dept #70 Medium 72 T-SQL PARTITION BY dept #71 Easy 73 T-SQL PARTITION BY dept #72 Medium 74 T-SQL PARTITION BY dept #73 Hard 75 T-SQL PARTITION BY dept #74 Medium 76 T-SQL PARTITION BY dept #75 Easy 77 T-SQL PARTITION BY dept #76 Medium 78 T-SQL PARTITION BY dept #77 Hard 79 T-SQL PARTITION BY dept #78 Medium 80 T-SQL PARTITION BY dept #79 Easy 81 T-SQL PARTITION BY dept #80 Medium 82 T-SQL PARTITION BY dept #81 Hard 83 T-SQL PARTITION BY dept #82 Medium 84 T-SQL PARTITION BY dept #83 Easy 85 T-SQL PARTITION BY dept #84 Medium 86 T-SQL PARTITION BY dept #85 Hard 87 T-SQL PARTITION BY dept #86 Medium 88 T-SQL PARTITION BY dept #87 Easy 89 T-SQL PARTITION BY dept #88 Medium 90 T-SQL PARTITION BY dept #89 Hard 91 T-SQL PARTITION BY dept #90 Medium 92 T-SQL PARTITION BY dept #91 Easy 93 T-SQL PARTITION BY dept #92 Medium 94 T-SQL PARTITION BY dept #93 Hard 95 T-SQL PARTITION BY dept #94 Medium 96 T-SQL PARTITION BY dept #95 Easy 97 T-SQL PARTITION BY dept #96 Medium 98 T-SQL PARTITION BY dept #97 Hard 99 T-SQL PARTITION BY dept #98 Medium 100 T-SQL PARTITION BY dept #99 Easy