Returning two counts in a query 1

[gregc73]

I am trying to write a query that would return two COUNT values. Basically, I have a table that contains JOBGROUP, JOBNAMES and STATUS. There are many JOBNAMES for each JOBGROUP. The status field can either be SUCCESS or NONE.

So the table looks like this:
JOBGROUP JOBNAME STATUS
A A1 NONE
A A2 NONE
A A3 SUCCESS
B B1 NONE
B B2 NONE
B B3 NONE

What I want to return is the following:

JOBGROUP TOTAL_JOBS TOTAL_SUCCESS
A 3 1
B 3 0


Any Ideas? Sorry if this is basic, but I'm novice at SQL.

 

[SQLSister]

SELECT JOBGROUP, COUNT(JOBNAME) AS Total_Jobs, 
SUM(CASE WHEN Status = 'Success' THEN 1 ELSE 0 END) AS Total_success 
FROM YourTable GROUP BY JOBGROUP

Does this get it for you?

Questions about posting. See faq183-874

 

[gregc73]

AWESOME!! Thank-you!