Page 5/7 - help!


#1


https://www.codecademy.com/courses/sql-table-transformation/lessons/subqueries/exercises/correlated-i?action=lesson_resume


What does this code mean? Especially the last line, I can't comprehend.



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.