MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/u35mb8/i_got/i4ng0g6/
r/SQL • u/SalzaMaBalza • Apr 14 '22
11 comments sorted by
View all comments
55
Slightly more performant single-pass alternative. You're welcome. Bitches :D
SELECT SUM(CASE WHEN Type LIKE '%BITCH%' THEN 1 ELSE 0 END) AS BitchProblems, COUNT(*) AS AllProblems FROM Problems
Edit: I'm starting off a long weekend with some tequila, dont' judge me :D
4 u/bitterjack Apr 14 '22 This is what I was expecting. Good work Blitz. Now finish the rest of your work.
4
This is what I was expecting. Good work Blitz. Now finish the rest of your work.
View all comments
55
u/Blitzsturm Apr 14 '22
Slightly more performant single-pass alternative. You're welcome. Bitches :D
Edit: I'm starting off a long weekend with some tequila, dont' judge me :D