pgsql count 条件查询

9.4以上版本

SELECT u.gender
     , count(*) FILTER (WHERE u.age  > 20 and u.name like '%张')    AS played
FROM   users u
GROUP  BY u.gender;

随意版本，可以简写

SELECT u.gender
     , count(u.age  > 20 and u.name like '%张')   AS played
FROM   users u
GROUP  BY u.gender;