you win! That's brilliant, I didn't even think about using an `IF`! • Aaron Parecki

38°F

Joschi Kuphal 吉 https://twitter.com/jkphl • Sep 16
something like this or similar (untested)?:

SELECT `date`, SUM(IF(success, 1, 0)) AS `success`, SUM(IF(success, 0, 1)) AS `fail` FROM t GROUP BY `date`

you win! That's brilliant, I didn't even think about using an `IF`!

Portland, Oregon, USA • 58°F

Fri, Sep 16, 2022 8:59am -07:00

1 like 2 replies
- Joschi Kuphal 吉
Have you written a response to this? Let me know the URL:
- Aaron Parecki twitter.com/aaronpk
  
  Yep it worked perfectly!
  
  Fri, Sep 16, 2022 4:01pm +00:00 (via brid.gy)
- Joschi Kuphal 吉 twitter.com/jkphl
  
  😎 did you try it already? it was off the top of my head …
  
  Fri, Sep 16, 2022 4:01pm +00:00 (via brid.gy)

Posted in /replies using quill.p3k.io