By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
name varchar(10),
week_no int,
year_no int
);
INSERT INTO test (name, week_no, year_no)
VALUES ('fb', 5, 2021),
('twitter', 1, 2022),
('twitter', 2, 2022),
('twitter', 3, 2022),
('twitter', 7, 2022),
('youtube', 21, 2022);
Records: 6 Duplicates: 0 Warnings: 0
SELECT name, year_no
FROM
(
SELECT *,
week_no -
ROW_NUMBER() OVER (PARTITION by name, year_no ORDER BY week_no) grp
FROM test
) T
GROUP BY name, year_no, grp
HAVING COUNT(*) >= 3
ORDER BY name, year_no
| name | year_no |
|---|---|
| 2022 |