Find all the tuples having temperature greater than ‘Paris’.

Question

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 city FROM weather WHERE city = ‘Paris’)

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

1.	Find all the tuples having 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