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:
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:
Even only having the right column (values), would be great
Thank you for any help!