Sql to summarize data

+---------------------------+
| PCLASS   |   GEN  | CASTE |
+---------------------------+
|5th Class | Male   | BC    |
|2nd Class | Female | SC    |
|5th Class | Female | ST    |
|2nd Class | Female | BC    |
+---------------------------+

+----------------------------------------------------------------------+
| CASTE    |        BC     |       SC      |       ST      |    GTOT   | 
+----------------------------------------------------------------------+
| PCLASS   |Male|Female|TOT|Male|Female|TOT|Male|Female|TOT|Male|Female|
+----------------------------------------------------------------------+
|2nd Class |  0 |   1  | 1 |  0 |  1   | 1 |  0 |  0   | 0 |  0 |  2   |
|5th Class |  1 |   0  | 1 |  0 |  0   | 0 |  0 |  1   | 1 |  1 |  1   |
+----------------------------------------------------------------------+
|Total                                                     |  1 |  3   |
+----------------------------------------------------------------------+

$result = $conn->query("select PCLASS, sum(case when GEN = 'Male' and  CASTE='SC' or CASTE='ST' or CASTE='BC' or CASTE='OC' or CASTE='Minority' then 1 else 0 end) Males,
sum(case when GEN = 'Female' and CASTE='SC' or CASTE='ST' or CASTE='BC' or CASTE='OC' or CASTE='Minority' then 1 else 0 end) Females, count(*) as Total from student
where OID='{$_SESSION["OID"]}' 
group by PCLASS"); 
				
while($row = mysqli_fetch_array($result)) {