I want to ask what is the meaning of question on Non-Correlated Subqueries III?


#1

To be honest, I don't understand the question.
"Using a subquery, find the average total distance flown by day of week and month".
What is the meaning of and month here?


#2

@scriptrunner84229,
For instance
the AVG(distance) flown on every-monday in Januari
the AVG(distance) flown on every-Tuesday in Januari
the AVG(distance) flown on every-weekday AND month


#3

Oh... thank you @leonhard.wettengmx.n

So, I just need to aggregate the data on week 1,2,3,4 grouped by day in the same month right?

Like
Month Day Average distance
January Sunday 135.32
January Monday 5235.6
January Tuesday
January Wednesday
January Thursday
January Friday
January Saturday

Something like that, right? I had thought they are different query, group by month and group by weekday.
Thanks for the explanation.


#4