MySQL 8.0

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

CREATE TABLE user_tbl(
`timestamp` date  ,
`user` varchar(15) );

insert into user_tbl values
('2022-09-10','BOB'),
('2022-08-20','BOB'),
('2022-08-15','SAL'),
('2022-05-07','MIKE'),
('2022-04-07','RON'),
('2022-03-07','BOB'),
('2022-02-07','SAL'),
('2022-01-15','JAKE');
    

CREATE TABLE tag_tbl (
`user` varchar(15), 
`tag` varchar(15) );
  
insert into tag_tbl values
('BOB','active'),
('SAL','pending'),
('MIKE','inactive'),
('RON','active'),
('JAKE','pending');

select * from user_tbl;
select * from tag_tbl;


timestamp
user


2022-09-10
BOB

2022-08-20
BOB

2022-08-15
SAL

2022-05-07
MIKE

2022-04-07
RON

2022-03-07
BOB

2022-02-07
SAL

2022-01-15
JAKE




user
tag


BOB
active

SAL
pending

MIKE
inactive

RON
active

JAKE
pending


select u.user,t.tag
from  user_tbl u 
inner join tag_tbl t on u.user=t.user
where  u.user not in ( select user
                         from user_tbl 
                         where `timestamp` >=(now() -INTERVAL 3 MONTH)
                       )  ;


user
tag


MIKE
inactive

RON
active

JAKE
pending

timestamp	user
2022-09-10	BOB
2022-08-20	BOB
2022-08-15	SAL
2022-05-07	MIKE
2022-04-07	RON
2022-03-07	BOB
2022-02-07	SAL
2022-01-15	JAKE