Given the Two Relations X and Y Below What Value Would Be Retrieved by Executing the Following SQL

question 47

Multiple Choice

Given the two relations X and Y below

$\begin{array}{l}\text { X: } \quad \begin{array} { l l } \text { A } & \text { B } \\\hline 7 & \mathrm {~s} \\2 & \text { Z }\end{array}\\\\\mathrm { Y } :\quad \begin{array} { l l } \mathrm { C } & \mathrm { D } \\\hline \mathrm { t } & 3 \\\mathrm { r } & 2\end{array}\end{array}$
What value would be retrieved by executing the following SQL statement?
SELECT Y.C FROM X,Y WHERE X.A < Y.D

• A) s
• B) z
• C) t
• D) r