SELECT school_name, count(student_school_id) AS n_of_student
FROM tbl_student
GROUP BY school_name;
SELECT school_name, count(student_school_id) AS n_of_student, avg(selected_response_score) as mean_score, STDEV(selected_response_score) as SD
FROM tbl_student
GROUP BY school_name;