Count function

Hi Eksperten!

I need to create a query with count function. Let say i have a employee table and columns  status. I would like to create query that can count total active and terminated employee. For examples result of query should look like as below:
Statue         total
Active         500
Terminated     150


Please help.