Correlated Subquery Lesson 5/7/ Table Transformations


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!

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


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