Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT grade_level, MAX(CASE WHEN rn = 1 THEN cnt END) first_result, MAX(CASE WHEN rn = 2 THEN cnt END) second_result, MAX(CASE WHEN rn = 3 THEN cnt END) third_result, SUM(cnt) total_enrolled FROM (SELECT q.*, ROW_NUMBER() OVER(PARTITION BY grade_level ORDER BY home_room) rn FROM ( SELECT grade_level, home_room, COUNT(*) cnt FROM students WHERE enroll_status = 0 AND schoolid IN (3) GROUP BY home_room, grade_level) q) GROUP BY grade_level ORDER BY grade_level;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.