This query only pickups 3 rows but there are at least 50 rows missing. How do I get the other rows
SELECT mbr_id, SUM(clm_pd_amt)`FROM gg.pop_clms WHERE clm_pd_amt >= 1000 AND year = 2022 GROUP BY clm_pd_amt, mbr_id
OUTPUT
mbr_id 1.2 sum(clm_pd_amt)
7099941 1034.38
7093029 2077.01
7090079 4907.44