How to count if conditional with a group by in Postgresql

Question

I have a table of FinishedGames with columns: category and a score. I need to know how many games by category finished with more than certain score, but I don't understand the count if structure in PostgreSQL.

select category, count(score) as rounds, count(if score > 7) as wins
from "FinishedGames" group by category;

Does anyone knows how to do this in PostgreSQL?

we can use, `having ` part. – Hari Kishore Sep 24 '21 at 11:10 — Hari Kishore, Sep 24 '21 at 11:10

score 8 · Accepted Answer · answered Aug 08 '16 at 17:07

8

you should use the CASE clause within the count function. e.g. COUNT(CASE WHEN score > 7 THEN 1 ELSE NULL END) (or SUM with 1 and 0 - same result...)

Regards, Jony

answered Aug 08 '16 at 17:07

cohenjo

576
3
5

It works with count or sum. Thank you. – Camilo Ortegón Aug 08 '16 at 17:23

How to count if conditional with a group by in Postgresql

1 Answers1