365 Days of Daily Coding: Day 54

I feel back ache once again. I was advised by the doctor that I was seeing to exercise regularly. I do tell myself to move around once after every 45 minutes. The first few rounds I am onto it but as the day progresses, I am completely attuned to my work and forget about it completely.

Advance SQL Challenge 1

My Solution

SELECT Workflow, Case1 + Case2 + Case3 AS Passed
FROM temp;

Alternative Solution

SELECT Workflow, SUM(Passfail) FROM
(
SELECT Workflow, CaseNumber, PassFail
FROM (SELECT Workflow, Case1, Case2, Case3 FROM temp) p
UNPIVOT (PassFail FOR CaseNumber IN (Case1,Case2,Case3)) 
)
GROUP BY Workflow
ORDER BY WOrkflow;

Inner Query

SELECT Workflow, CaseNumber, PassFail
FROM (SELECT Workflow,Case1,Case2,Case3
 FROM temp) p
UNPIVOT (PassFail FOR CaseNumber IN (Case1,Case2,Case3)) 

Output

WORKFLOW	CASENUMBER	PASSFAIL
Alpha	CASE1	0
Alpha	CASE2	0
Alpha	CASE3	0
Bravo	CASE1	0
Bravo	CASE2	1