We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Please check first if you selected MS SQL Server from the dropdown list. If so, my solution should work fine, I even checked it today by inserting the code to the hackerrank's code editor and it passed the sample test case.
Anyway, as we are supposed to print the total number of challenges created by each student the WHERE clause:
ensures that the result includes all students with the maximum number of challenges as well as students whose number of challenges is lower but they are unique (no other student has the same number of challenges created). Hope it helps.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Challenges
You are viewing a single comment's thread. Return to all comments →
Please check first if you selected MS SQL Server from the dropdown list. If so, my solution should work fine, I even checked it today by inserting the code to the hackerrank's code editor and it passed the sample test case. Anyway, as we are supposed to print
the total number of challenges created by each student
the WHERE clause:ensures that the result includes all students with the maximum number of challenges as well as students whose number of challenges is lower but they are unique (no other student has the same number of challenges created). Hope it helps.