4. Non-Correlate Sub queries 2 - Is this right?

Hi,
Could someone confirm if this is right, it seems to pass me but I got the error (See image) coming up on the screen.
Also what does group by 1, 2, 3 do?

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>

<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

```

SELECT a.dep_month,
a.dep_day_of_week,
AVG(a.flight_distance) AS average_distance
FROM (
SELECT dep_month,
dep_day_of_week,
dep_date,
SUM(distance) AS flight_distance
FROM flights
GROUP BY 1,2,3
) a
GROUP BY 1,2
ORDER BY 1,2;

<do not remove the three backticks above>

The Group 1,2,3, groups it by the 1st, 2nd, and 3rd variables in your Select statement (dep_month, dep_day_of_week, and dep_date.

In your outer query, you group by the 1st (dep_month - from the inner query group by) and 2nd (dep_day_of_the_week)

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