K1000 Service Desk Report: # of tickets created per week
I want to create a report for the # of tickets created each week for a date range. I have a query to get a count for one date range, but I'm wondering if I could have a date range broken down by week. So, the date range might be a month and I want it to give me the # for each week in that date range. This is a bit beyond my SQL skill level. Here's my query for simple count for a date range:
Where HD_TICKET.CREATED between '2013-07-28' AND '2013-08-03'