I have table like

Std_id profile
1 HIGH
2 HIGH
3 MEDIUM
4 LOW
5 HIGH
6 MEDIUM

Now i want to get a report that should inform me the number of students in HIGH, MEDIUM and LOW profile....


Please Help me

Select profile, count(*)
from table
where profile IN ('HIGH', 'MEDIUM', 'LOW')
group by profile;

Thanks For the Reply but, i want that in the following format.


HIGH MEDIUM LOW
2 2 5

Select
SUM(CASE WHEN profile = 'HIGH' THEN AMT ELSE 0 END) As "HIGH",
SUM(CASE WHEN profile = 'MEDIUM' THEN AMT ELSE 0 END) As "MEDIUM",
SUM(CASE WHEN profile = 'LOW' THEN AMT ELSE 0 END) As "LOW"
from
(Select profile, count(*) as "AMT"
from table
where profile IN ('HIGH', 'MEDIUM', 'LOW')
group by profile);