MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE clicks_plus_noClicks_raw (`EmailAddress` VARCHAR(11), `sentdate` VARCHAR(100), `clickdate` VARCHAR(100), `pid` INTEGER);
INSERT INTO clicks_plus_noClicks_raw (`EmailAddress`, `sentdate`, `clickdate`, `pid`) VALUES
  ('a@gmail.com', '15 August 2021 23:30', null, '4000'),
  ('b@gmail.com', '15 August 2021 23:30', null, '5000'),
  ('b@gmail.com', '15 August 2021 23:30', null, '5000'),
  ('b@gmail.com', '15 August 2021 23:30', null, '5000'),
  ('b@gmail.com', '16 August 2021 23:30', null, '5000'),
  ('c@gmail.com', '16 August 2021 23:30', '17 August 2021 23:30', '5000'),
  ('b@gmail.com', '16 August 2021 23:30', null, '8000');
SELECT EmailAddress, 
       pid,
       COUNT(clickdate) count
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY EmailAddress, pid ORDER BY sentdate DESC) rn
  FROM clicks_plus_noClicks_raw
) t
WHERE rn <= 3
GROUP BY EmailAddress, pid
HAVING COUNT(*) >= 3;


EmailAddress
pid
count


b@gmail.com
5000
0