Question $1$

Which statement is NOT a correlated sub$-$query?

select $*$ from menu

where pizza $=($select pizza from menu where country $=$ 'iran'$)$;

Select productdescription, productstandardprice, productfinish from product$\_$t Table$\_$a where productstandardprice $<$

$($select avg $($productstandardprice$)$

from product$\_$t Table$\_$b

where Table$\_$b$.$productfinish$-$Table$\_$a$.$productfinish$)$;

Select distinct $($orderid$)$

from orderline$\_$t

where EXISTS $($Select $*$

from product$\_$t where productid$=$orderline$\_$t$.$productid and productfinish$=$'Oak'$)$;