pgsql中count 条件查询

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