Correlated Subquery Lesson 5/7/ Table Transformations


#1


So this code passes correctly, I was just curious for what does the final statement mean. What is the significance of having carrier = f.carrier? Thanks!


SELECT id
FROM flights AS f
WHERE distance < (
 SELECT AVG(distance)
 FROM flights
 WHERE carrier = f.carrier);


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.