MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE AnswerTable(
   seqAnswer INTEGER  NOT NULL PRIMARY KEY 
  ,question1 INTEGER  NOT NULL
  ,question2 INTEGER  NOT NULL
  ,question3 INTEGER  NOT NULL
);
INSERT INTO AnswerTable(seqAnswer,question1,question2,question3) VALUES (1,3,2,3);
INSERT INTO AnswerTable(seqAnswer,question1,question2,question3) VALUES (2,4,1,2);
INSERT INTO AnswerTable(seqAnswer,question1,question2,question3) VALUES (3,1,3,4);
CREATE TABLE ReturnTable(
   id        INTEGER  
  ,seqreturn INTEGER  NOT NULL
  ,question1 INTEGER  NOT NULL
  ,question2 INTEGER  NOT NULL
  ,question3 INTEGER  NOT NULL
);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (1,3,2,3,1);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (2,1,2,2,1);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (3,2,4,3,1);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (4,1,3,2,4);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (5,3,1,3,1);
INSERT INTO ReturnTable(id,seqreturn,question1,question2,question3) VALUES (6,3,1,3,2);
select
    a.seqAnswer test_number,
    sum(a.question1 = r.question1) question1,
    sum(a.question2 = r.question2) question2,
    sum(a.question3 = r.question3) question3,
    count(*) total
from AnswerTable a
inner join ReturnTable r on r.seqReturn = a.seqAnswer
group by a.seqAnswer
order by test_number


test_number
question1
question2
question3
total


1
1
2
0
2

2
1
0
0
1

3
2
3
0
3