I have a date in my SQL database that I want to group the data by that date and Type. The Year/Month/Week/Day each entry would count as 1.
Example Dates
1/2/2018 - P
1/5/2018 - P
1/10/2018 - P
1/15/2018 - V
1/20/2018 - V
1/28/2018 - V
Should Produce
Jan - 6
Week 1 - 2P
Week 2 - 1V 1P
Week 3 - 1V
Week 4 - 1V