Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. league_id user_id outcome_id
  2. 5 1 1
  3. 5 1 4
  4. 5 2 1
  5.  
  6. league_id user_id outcome_id
  7. 5 1 FAIL
  8. 5 2 PASS
  9.  
  10. SELECT league_id,user_id,
  11. CASE WHEN outcome=0 THEN 'PASS' ELSE 'FAIL' END as outcome_id
  12. FROM
  13. (
  14. SELECT league_id,user_id,SUM(CASE WHEN outcome_id=4 THEN 1 ELSE 0 END) as outcome
  15. FROM tableName
  16. GROUP BY league_id,user_id
  17. ) As Z
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement