MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
    name varchar(20),
    week_no int,
    year_no int
);
INSERT INTO test (name, week_no, year_no)
VALUES ('fb', 5, 2021), 
       ('twitter', 1, 2023),
       ('twitter', 2, 2022),
       ('twitter', 3, 2022), 
       ('twitter', 7, 2022),
       ('youtube', 21, 2022);

Records: 6  Duplicates: 0  Warnings: 0


select * from test;


name
week_no
year_no


fb
5
2021

twitter
1
2023

twitter
2
2022

twitter
3
2022

twitter
7
2022

youtube
21
2022


SELECT t1.name,t1.year_no
FROM   test t1
INNER JOIN   test t2 ON t1.name=t2.name AND t1.year_no=t2.year_no
INNER JOIN   test t3 ON t1.name=t3.name AND t1.year_no=t3.year_no
WHERE   t2.week_no = t1.week_no + 1 
AND    t3.week_no = t1.week_no + 2 


name
year_no

name	week_no	year_no
fb	5	2021
twitter	1	2023
twitter	2	2022
twitter	3	2022
twitter	7	2022
youtube	21	2022