SQLize Online / PHPize Online  /  SQLtest Online

create table sales ( dt date not null, inn int not null, REV money not null, primary key (dt, inn) ) go insert into sales (dt, inn, REV) values ('20220101', 1, 9226), ('20220201', 1, 10166), ('20220301', 1, 10916), ('20220401', 1, 8824), ('20220501', 1, 7449), ('20220601', 1, 6243), ('20220701', 1, 7403), ('20220801', 1, 7145), ('20220901', 1, 6948), ('20221001', 1, 7634) go select inn from sales where REV < 10000 group by inn having count(dt) = 10 go select inn from sales --where REV < 10000 group by inn having count(dt) = 10 go select inn from sales group by inn having count(rev) = count(case when rev < 10000 then 1 end) go