|
|
|
|
|
|
by RustLove
1291 days ago
|
|
|
Wow, I had no idea you could do multiple aggregates in a single query like that. I've always used the SUM(CASE...) method, but the COUNT(x=y) way is much cleaner and more efficient. Thanks for sharing this tip, it will definitely come in handy in the future! |
|
|