HI SQL Team,
I'm trying to Count Rows for multiple Dates. The trick is that I do not have the clearance to create a new Table.
I've gotten here:
SELECT
COUNT (*)
FROM SampleTable a
WHERE a.Name = 'Charles'
AND a.Date = '07-26-2016'
My goal would be the number of 'Charles' occurrences there are on each date from the past two years. My hope is to come to something like this:
07-26-2016 13
07-25-2016 17
07-24-2016 12
...
07-25-2014 15
07-26-2014 14
Even only having the right column (values), would be great
Thank you for any help!
Best,
E46 Novice