We can further break the gender column to get number of male and female in each class by using SQL case. SELECT class, count(*) as Total, sum(CASE WHEN gender ...
確定! 回上一頁