(mis) can you please help me on which SQL would be the result table

2nd question

ABLE 1 TABLE 2 \begin{tabular}{|c|c|c|} \hline ColA & ColB & ColC \\ \hlinea1 & 15 & \\ \hlinea2 & & 7 \\ \hlinea3 & 13 & 8 \\ \hlinea4 & 6 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline X & Y & Z & FK_ColA \\ \hline X1 & MN & 16.3 & a1 \\ \hline X2 & ND & & \\ \hline X3 & & 18.9 & a2 \\ \hline X4 & & 16.2 & a1 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline CoSULT & ColB & ColC & X & Y & Z & FK_ColA \\ \hline a1 & 15 & NULL & X1 & MN & 16.3 & a1 \\ \hline a1 & 15 & NULL & X4 & NULL & 16.2 & a1 \\ \hline a2 & 7 & NULL & X3 & NULL & 18.9 & a) \\ \hline \end{tabular} Showr above are two reisted tables and the cesuit table produced by a query - TABLE1 with columes Colt ColB, ColC The colurn ColA serves as ene primary key - TABL. E2 with columes x,y,z and FK ColA. The columin FK. ColA serves as the foroign key Wick of the following SOL querens would produco the shown RESUL.T table? abistion cot 71.ColA=72.Fx colh I.t.tict * cos71.Colh=72,Fh(coth anteser ced 72,hicolh= TH,Co all 12,ry2Colh=71,Colh arturat: ds Tt.ColA = T2.12 ColA RESULT \begin{tabular}{|c|c|c|c|c|c|c|} \hline ColA & ColB & ColC & X & Y & Z & FK_ColA \\ \hlinea1 & 15 & NULL & X1 & MN & 16.3 & a1 \\ \hline a1 & 15 & NULL & X4 & NULL & 16.2 & a1 \\ \hline a2 & 7 & NULL & X3 & NULL & 18.9 & a2 \\ \hline a3 & 13 & 8 & NULL & NULL & NULL & NULL \\ \hline a4 & 6 & NULL & NULL & NULL & NULL & NULL \\ \hline NULL & NULL & NULL & X2 & ND & NULL & NULL \\ \hline \end{tabular} Shown above are two related tables and the result table produced by a query: - TABLE1 with columns: ColA, ColB, ColC. The column ColA serves as the primary key - TABLE2 with columns: X, Y, Z, and FK_ColA. The column FK_ColA serves as the foreign key Which of the following SQL queries would produce the shown RESULT table? SELisct FROM TABLE1 T1 LEFT JOTN TABLE2 T2 ON T1.COIA =T2FK_CO1A Shown above are two related tables and the result table produced by a query: - TABLE1 with columns: ColA, ColB, ColC. The column ColA serves as the primary key - TABLE2 with columns: X, Y,Z, and FK_ColA. The column FK_ColA serves as the foreign key Which of the following SQL queries would produce the shown RESULT table? SELECT * EROM TABLE1 T1 LEET JOIN TABLE2 T2 ONT1.ColA=T2FKCColA SELECT * FROM ThBLE1 T1 JOIN TABLE2 T2 ON T1. ColA =T2.FKCColA SELECM * RRON TABLE2 T2 JOIN TABLE1 T1 ON T2. FK_ColA =T1.C01A SELRCT * EROM TABLE1 T1 RIGHT JOIN TABLE2 T2 ON T1. ColA =T2FK ColA SELBCT * FROM TABLE2 T2 LEFT JOIN TABLE1 T1 ON T2. FK ColA =T1ColA ABLE 1 TABLE 2 \begin{tabular}{|c|c|c|} \hline ColA & ColB & ColC \\ \hlinea1 & 15 & \\ \hlinea2 & & 7 \\ \hlinea3 & 13 & 8 \\ \hlinea4 & 6 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline X & Y & Z & FK_ColA \\ \hline X1 & MN & 16.3 & a1 \\ \hline X2 & ND & & \\ \hline X3 & & 18.9 & a2 \\ \hline X4 & & 16.2 & a1 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline CoSULT & ColB & ColC & X & Y & Z & FK_ColA \\ \hline a1 & 15 & NULL & X1 & MN & 16.3 & a1 \\ \hline a1 & 15 & NULL & X4 & NULL & 16.2 & a1 \\ \hline a2 & 7 & NULL & X3 & NULL & 18.9 & a) \\ \hline \end{tabular} Showr above are two reisted tables and the cesuit table produced by a query - TABLE1 with columes Colt ColB, ColC The colurn ColA serves as ene primary key - TABL. E2 with columes x,y,z and FK ColA. The columin FK. ColA serves as the foroign key Wick of the following SOL querens would produco the shown RESUL.T table? abistion cot 71.ColA=72.Fx colh I.t.tict * cos71.Colh=72,Fh(coth anteser ced 72,hicolh= TH,Co all 12,ry2Colh=71,Colh arturat: ds Tt.ColA = T2.12 ColA RESULT \begin{tabular}{|c|c|c|c|c|c|c|} \hline ColA & ColB & ColC & X & Y & Z & FK_ColA \\ \hlinea1 & 15 & NULL & X1 & MN & 16.3 & a1 \\ \hline a1 & 15 & NULL & X4 & NULL & 16.2 & a1 \\ \hline a2 & 7 & NULL & X3 & NULL & 18.9 & a2 \\ \hline a3 & 13 & 8 & NULL & NULL & NULL & NULL \\ \hline a4 & 6 & NULL & NULL & NULL & NULL & NULL \\ \hline NULL & NULL & NULL & X2 & ND & NULL & NULL \\ \hline \end{tabular} Shown above are two related tables and the result table produced by a query: - TABLE1 with columns: ColA, ColB, ColC. The column ColA serves as the primary key - TABLE2 with columns: X, Y, Z, and FK_ColA. The column FK_ColA serves as the foreign key Which of the following SQL queries would produce the shown RESULT table? SELisct FROM TABLE1 T1 LEFT JOTN TABLE2 T2 ON T1.COIA =T2FK_CO1A Shown above are two related tables and the result table produced by a query: - TABLE1 with columns: ColA, ColB, ColC. The column ColA serves as the primary key - TABLE2 with columns: X, Y,Z, and FK_ColA. The column FK_ColA serves as the foreign key Which of the following SQL queries would produce the shown RESULT table? SELECT * EROM TABLE1 T1 LEET JOIN TABLE2 T2 ONT1.ColA=T2FKCColA SELECT * FROM ThBLE1 T1 JOIN TABLE2 T2 ON T1. ColA =T2.FKCColA SELECM * RRON TABLE2 T2 JOIN TABLE1 T1 ON T2. FK_ColA =T1.C01A SELRCT * EROM TABLE1 T1 RIGHT JOIN TABLE2 T2 ON T1. ColA =T2FK ColA SELBCT * FROM TABLE2 T2 LEFT JOIN TABLE1 T1 ON T2. FK ColA =T1ColA