MySQL query returning fewer results when GROUP BY removed?

Frankly I'm surprised that it runs without just giving you an error for using aggregate functions without a group by, maybe has something to do with the fact that all your fields are calculated values. Anyway, get rid of all your aggregate functions to get to the underlying data.

The fact that you are removing the GROUP BY directive makes it unneeded for the execution of the query to subdivide your results on date_idx. The number count is equally going from 1 and 7 in the GROUPED query to 8 in the NON GROUPED query. Without the GROUPBY directive, there is no reason for the query executor to give you more than one row with aggregated information, because you simply did not ask for that seperation.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.