Given the two relations X and Y below what value would be retrieved by executing the following SQL statement? select Y.C
From X, Y
Where X.A

Question

Given the two relations X and Y below  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

Quizplus · Accepted Answer

We can break down the SQL statement as follows:
- We want to SELECT the value of Y's "C" column. 
- We are pulling data FROM tables X and Y. 
- We want to filter the results to only show us rows where X's "A" column is LESS THAN Y's "D" column.

If we look at the data in tables X and Y, we can see that the only row where X's "A" column is less than Y's "D" column is the second row, where X.A = 2 and Y.D = 3. In this row, Y's "C" column has the value of "t". Therefore, the SQL statement would return "t".

Given the Two Relations X and Y Below What