2 count with criteria

I have one table EV

EV_CODE     PK
EV_STATUS
EV_CLASS

I want 2 count in the same select:

how many ev_code i have for each ev_class

when ev_status is (A or R )

and when ev_status is C

result like ev_class A/R C   

                X       58     15
                Y       22     47

thanks Received on Tue Jul 02 2002 - 05:23:37 CDT