I am hoping someone can help me with a query I am trying to create.
I have one Table with 2 columns: MovieName and MovieDate
I am trying to create a query that will show the number of hits on each movie grouped by month, but only from the previous 12 months from the current date.
I have tried...