Project 2

2.

4.

16. Calcumlation of all the students in the college A and then for specific category diving it.

SELECT count(*) from college_a_hs; = 1157 (Percentage : 1157/(1157+724+4003)*100)
SELECT count(*) from college_a_se; = 724 (Percentage : 724/(1157+724+4003)*100)
SELECT count(*) from college_a_sj; = 4003 (Percentage : 4003/(1157+724+4003)*100)
SELECT count(*) from college_b_hs; = 199 (Percentage : 199/(199+201+1859)*100)
SELECT count(*) from college_b_se; = 201 (Percentage : 201/(199+201+1859)*100)
SELECT count(*) from college_b_sj; = 1859 (Percentage : 1859/(199+201+1859)*100)