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?

@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

1 Like

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.