Find the dates where number of trips from town Rostov were the maximum. Result set: number of trips, date.
It seemed to me, that the formulation is extremely clear. When this exercise still was at the second stage, it did not cause any questions. The difference in class I suppose :-). Now however the necessity to answer similar questions arises so often that I had to write this FAQ.
Here a typical example of wrong query:
The grouping by date allows us to count up distribution of number of the Rostov flights by days. While all is true, but last step is absolutely senseless. What for one more grouping by date is needed if all is already grouped, i.e. result set includes only one row for each date?
It seems, that the author of the above solution thus tried to find a maximum, but has received the same set. Let us take sample distribution of flights number by dates:
In accordance with the task formulation we should receive only one row:
I hope now that it is clear what you should do to solve this problem, and I'll not answer more letters on this occasion :-).