Can someone help me with a SQL view? I need a listing of total counts for each product searchable by month. The results should show the URL/website link to each product (I can't quite figure out everything in the URL).
Here's what I'm looking for
Product Name | Total Hits | Product URL
Product 1 45 www.myurl/category1/product1---.aspx
Again, I'll be using a WHERE (date of statistics) = '8' (or any other month).