~[tlist_sql;
SELECT Schools.Name AS School, Schools.School_Number AS School_Number,
SUM ( CASE WHEN Students.Grade_Level = -3 THEN 1 ELSE NULL END ) AS Minus_Three,
SUM ( CASE WHEN Students.Grade_Level = -2 THEN 1 ELSE NULL END ) AS Minus_Two,
SUM ( CASE WHEN Students.Grade_Level = -1 THEN 1 ELSE NULL END ) AS Minus_One,
SUM ( CASE WHEN Students.Grade_Level = 0 THEN 1 ELSE NULL END ) AS K,
SUM ( CASE WHEN Students.Grade_Level = 1 THEN 1 ELSE NULL END ) AS One,
SUM ( CASE WHEN Students.Grade_Level = 2 THEN 1 ELSE NULL END ) AS Two,
SUM ( CASE WHEN Students.Grade_Level = 3 THEN 1 ELSE NULL END ) AS Three,
SUM ( CASE WHEN Students.Grade_Level = 4 THEN 1 ELSE NULL END ) AS Four,
SUM ( CASE WHEN Students.Grade_Level = 5 THEN 1 ELSE NULL END ) AS Five,
SUM ( CASE WHEN Students.Grade_Level = 6 THEN 1 ELSE NULL END ) AS Six,
SUM ( CASE WHEN Students.Grade_Level = 7 THEN 1 ELSE NULL END ) AS Seven,
SUM ( CASE WHEN Students.Grade_Level = 8 THEN 1 ELSE NULL END ) AS Eight,
SUM ( CASE WHEN Students.Grade_Level = 9 THEN 1 ELSE NULL END ) AS Nine,
SUM ( CASE WHEN Students.Grade_Level = 10 THEN 1 ELSE NULL END ) AS Ten,
SUM ( CASE WHEN Students.Grade_Level = 11 THEN 1 ELSE NULL END ) AS Eleven,
SUM ( CASE WHEN Students.Grade_Level = 12 THEN 1 ELSE NULL END ) AS Twelve,
SUM ( CASE WHEN Students.Grade_Level = 13 THEN 1 ELSE NULL END ) AS Thirteen,
SUM ( CASE WHEN Students.Grade_Level < 99 THEN 1 ELSE NULL END ) AS Total,
Schools.SortOrder
FROM Students
INNER JOIN Schools
ON Schools.School_Number = Students.SchoolID
WHERE Students.Enroll_Status = 0 AND Students.Grade_Level < 99
GROUP BY Schools.Name, Schools.School_Number, Schools.SortOrder
ORDER BY Schools.SortOrder;alternatecolor]
[/tlist_sql]
~[tlist_sql;
SELECT 'Total' AS School,
SUM ( CASE WHEN Students.Grade_Level = -3 THEN 1 ELSE NULL END ) AS Minus_Three,
SUM ( CASE WHEN Students.Grade_Level = -2 THEN 1 ELSE NULL END ) AS Minus_Two,
SUM ( CASE WHEN Students.Grade_Level = -1 THEN 1 ELSE NULL END ) AS Minus_One,
SUM ( CASE WHEN Students.Grade_Level = 0 THEN 1 ELSE NULL END ) AS K,
SUM ( CASE WHEN Students.Grade_Level = 1 THEN 1 ELSE NULL END ) AS One,
SUM ( CASE WHEN Students.Grade_Level = 2 THEN 1 ELSE NULL END ) AS Two,
SUM ( CASE WHEN Students.Grade_Level = 3 THEN 1 ELSE NULL END ) AS Three,
SUM ( CASE WHEN Students.Grade_Level = 4 THEN 1 ELSE NULL END ) AS Four,
SUM ( CASE WHEN Students.Grade_Level = 5 THEN 1 ELSE NULL END ) AS Five,
SUM ( CASE WHEN Students.Grade_Level = 6 THEN 1 ELSE NULL END ) AS Six,
SUM ( CASE WHEN Students.Grade_Level = 7 THEN 1 ELSE NULL END ) AS Seven,
SUM ( CASE WHEN Students.Grade_Level = 8 THEN 1 ELSE NULL END ) AS Eight,
SUM ( CASE WHEN Students.Grade_Level = 9 THEN 1 ELSE NULL END ) AS Nine,
SUM ( CASE WHEN Students.Grade_Level = 10 THEN 1 ELSE NULL END ) AS Ten,
SUM ( CASE WHEN Students.Grade_Level = 11 THEN 1 ELSE NULL END ) AS Eleven,
SUM ( CASE WHEN Students.Grade_Level = 12 THEN 1 ELSE NULL END ) AS Twelve,
SUM ( CASE WHEN Students.Grade_Level = 13 THEN 1 ELSE NULL END ) AS Thirteen,
SUM ( CASE WHEN Students.Grade_Level < 99 THEN 1 ELSE NULL END ) AS Total
FROM Students
WHERE Students.Enroll_Status = 0 AND Students.Grade_Level < 99]