In MySQL, the same query thrashes really hard. After some experimentation, it seems like the subquery itself is the problem. For instance: ...

I have a SQL query that will get me all the data I want for the upcoming events, but I don't know how to split up the results by month. Here is the query I have: ...