That was fast, we have a winner! SELECT `date`, SUM(IF(... • Aaron Parecki

50°F

Aaron Parecki https://aaronparecki.com/ • Sep 16
Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?

That was fast, we have a winner!

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

https://twitter.com/jkphl/status/1570804284060475392

Portland, Oregon, USA • 58°F

Fri, Sep 16, 2022 9:01am -07:00

10 likes 3 replies
Have you written a response to this? Let me know the URL:
- Aaron Parecki twitter.com/aaronpk
  
  my problem was I couldn't even figure out how to ask this with words so I wasn't sure what to search for!
  
  Fri, Sep 16, 2022 4:24pm +00:00 (via brid.gy)
- Guillermo Arellano twitter.com/MeetGuillermo
  
  Who needs StackOverflow when you have Twitter?
  
  Fri, Sep 16, 2022 4:22pm +00:00 (via brid.gy)
- Joschi Kuphal 吉 twitter.com/jkphl
  
  Actually, the first IF isn't necessary, and I didn't care about stripping the time part, so @paw's suggestion is a bit more accurate:
  
  Fri, Sep 16, 2022 4:10pm +00:00 (via brid.gy)

Posted in /replies using quill.p3k.io