By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH foo( ID, Day, Total ) AS
(
SELECT '01', date'2020-01-01' , 10 FROM dual UNION ALL
SELECT '01', date'2020-01-02' , 50 FROM dual UNION ALL
SELECT '01', date'2020-01-03' , 50 FROM dual UNION ALL
SELECT '01', date'2020-01-04' , 50 FROM dual UNION ALL
SELECT '01', date'2020-01-05' , 20 FROM dual UNION ALL
SELECT '02', date'2020-01-01' , 10 FROM dual UNION ALL
SELECT '02', date'2020-01-02' , 10 FROM dual UNION ALL
SELECT '02', date'2020-01-03' , 10 FROM dual UNION ALL
SELECT '02', date'2020-01-04' , 10 FROM dual UNION ALL
SELECT '02', date'2020-01-05' , 10 FROM dual
)
SELECT ID
FROM foo
GROUP BY ID
HAVING COUNT( distinct day )>=3 AND SUM( NVL(Total,0) ) >= 150
| ID |
|---|
| 01 |