C#,Windows Form, WPF, LINQ, Entity Framework Examples and Codes

SQL Query to List only the Count of Female Students in Each Class

5 years ago

In this SQL Query Example, We’ll learn How to List only the Count of Female Students in Each Class.

SQL Query:


Select class,gender,count(*) as StudentCount 
from students 
where gender = 'F'
group by gender,class

Select class,gender,count(*) as StudentCount

from students

where gender = 'F'

group by gender,class