MySQL 5.7

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

CREATE TABLE accounts
    (`id` int, `username` varchar(7), `role` int)
;
    
INSERT INTO accounts
    (`id`, `username`, `role`)
VALUES
    (1, 'pete101', 2),
    (2, 'JohnnyA', 1),
    (3, 'Anno65', 1),
    (4, 'tom', 1),
    (5, 'koala3', 2)
;
CREATE TABLE events
    (`id` int,  `date` date, `accountID` varchar(10))
;
    
INSERT INTO events
    (`id`, `date`, `accountID`)
VALUES
    (1, '02-04-20', 3),
    (2, '10-04-20', 5),
    (3, '07-04-20', 4),
    (4, '10-04-20', 2),
    (5, '10-04-20', 1)
;
SELECT 
e.id,a.username,e.`date`, e.accountID
FROM events e JOIN accounts a ON e.accountID = a.id WHERE e.date = '10-04-20' AND a.role = '2'
Order BY e.id


id
username
date
accountID


2
koala3
2010-04-20
5

5
pete101
2010-04-20
1