MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1
    (`ID` varchar(5), `Name` varchar(8))
;
    
INSERT INTO table1
    (`ID`, `Name`)
VALUES
    ('1', 'Brie'),
    ('2', 'Ray'),
    ('3', 'James')
;


Records: 3  Duplicates: 0  Warnings: 0


CREATE TABLE table2
    (`ID` int, `Q_id` int, `Q_no` int, `ans` varchar(1))
;
    
INSERT INTO table2
    (`ID`, `Q_id`, `Q_no`, `ans`)
VALUES
    (1, 2304., 1, 'A'),
    (1, 2304., 2, 'A'),
    (1, 2305., 1, 'C'),
    (2, 2304., 2, 'A'),
    (2, 2305., 1, 'C'),
    (3, 2304., 1, 'A'),
    (3, 2305., 2, 'D')
;

Records: 7  Duplicates: 0  Warnings: 0


CREATE TABLE table3
    (`Q_id` varchar(8), `Q_no` varchar(6), `correct_ans` varchar(13))
;
    
INSERT INTO table3
    (`Q_id`, `Q_no`, `correct_ans`)
VALUES
    ('2304.', '1', 'A'),
    ('2304.', '2', 'B'),
    ('2305.', '1', 'C'),
    ('2305.', '2', 'D')
;

Records: 4  Duplicates: 0  Warnings: 0


SELECT t1.ID,t1.`Name`,COUNT(*) as correct_answers
FROM table1 t1 
  JOIN table2 t2 ON t1.ID = t2.ID
  JOIN table3 t3 ON t2.`Q_id` = t3.`Q_id` AND  t2.`Q_no` = t3.`Q_no`
WHERE t3.`correct_ans` = t2.`ans`
GROUP BY t1.ID,t1.`Name`
order by t1.ID


ID
Name
correct_answers


1
Brie
2

2
Ray
1

3
James
2