It is asked if LHS can be replaced by RHS , so basically does RHS able to produce same ROWS and COLUMNS that LHS can PRODUCE ?
-> In option (b) , in LHS , we first TAKE OUT a column A1 and then apply condition C1 on THAT column .
So it is guaranteed that condition is applied on A1.
Thus we get Column A1 and some Rows in answer according to condition C1.
Now in RHS we apply SAME condition C1 on WHOLE TABLE .
Whole Table will definitely contain Column A1.
And then we keep only Column A1,and eliminate Rest , same as lhs.
-> In option (b), it is inverse of option (b).
LHS = First Condition c1 Is Applied on Whole table. They Have Not Mentioned that condition is applied on which column. Lets assume its applies on A2. Thus we get some rows.
Now Projection applied on A1. Thus we get column A1 and rows(which satisfy c1) in OUTPUT.
But In RHS , they are Projecting column A1 and applying same PREVIOUS Condition C1 which we assumed is applied on A2.
But because we projected only A1 from table we cant apply condition on A2 (bcoz it doesnt exist) . ERROR.
ITS JUST THE ORDER THAT MATTERS HERE AND WHETHER RHS CAN PRODUCE SAME OUTPUT AS LHS IN ALL CASES.