PLEASE SAVE THIS QUESTION FOR THE END AS IT CAN BE TRICKY AND DIFFICULT

Given three relations, $R(A,B),S(C,D),$ and $T(E,F),$ as shown in the image below:Compute the result of the query:

SELECT A$,$ F$,$ SUM$($C$),$ SUM$($D$)$

FROM R$,$ S$,$ T

WHERE B $=$ C AND D $=$ E

GROUP BY A$,$ F

HAVING COUNT$(*)>1$

HINTS:

$1.$ ChatGPT won't give you the correct answer :$)$

$2.$ Start with joining the tables using the where clause. You will get $8$ rows only.

$3.$ After the COUNT$(*)$ clause, you will have $7$ rows remaining

Which row from the options below appears in the result?

Choice $1$ of $4$:$(0,1,2,2)$

Choice $2$ of $4$:$(1,1,1,2)$

Choice $3$ of $4$:$(0,1,2,1)$

Choice $4$ of $4$:$(0,0,1,1)$