**tblticket** 

**id issue status**  

1 test 1  

2 test 2  

3 test 3 

i want to find count based on status 1,2,3 and so on 

i write 3 sql statment as follows

select count(\*) from ticket where status=1  

select count(\*) from ticket where status=2  

select count(\*) from ticket where status=3 

any way to simplify this into single query