SQLize Online / PHPize Online  /  SQLtest Online

create table sales ( dt date not null, inn int not null, REV money not null ) 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