根据单行中存在的条件选择所有行

Question

给定如下表:

<表类> id year_month 数 tbody><<tr>12022 _01912022 _02512022 _03422022 _011122022 _021322022 _031032022 _01332022 _021532022 _034

with cte as (
select id from table_a group by id having max(count) > 10)
select t.id,
t.year_month,
t.count
from table_a t
join cte
using (id);