Find all the tuples having a temperature greater than Paris .

Question

Find all the tuples having a temperature greater than  Paris .

TuteeHUB · Accepted Answer

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city =  Paris )

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city =  Paris

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city =  Paris )

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city =  Paris )

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature >  Paris  temperature

1.	Find all the tuples having a temperature greater than Paris .
A.	SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = Paris
B.	SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = Paris )
C.	SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = Paris )
D.	SELECT * FROM weather WHERE temperature > Paris temperature
Answer» B. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = Paris )

Discussion