MySql export issue

[JadedLucidity]

I'm hoping someone can help me with this.

 

I have a table with three columns

 

1 - auto indexed number

2 - product number (repeats depending on date)

3 - date

 

so product 123 was sold  on January 1, 2005, 8:30 AM and again on January 1, 2006, 9:15 PM etc etc etc. Lots of duplicates

 

How do I query to just say product 123 had 15 sales between January 1, 2005 and January 1, 2006. Is there a way just to count how many between two dates and then export this report directly to excel?

 

So it would be:

 

Product id              Number of sales

123                        15

124                        12

 

Something like that. Are there any tutorials on this?

 

Thanks

 

[artacus]

SELECT product_no, COUNT(*) AS num_sold
FROM sales
WHERE the_date BETWEEN '2005-01-01' AND '2006-01-01'
GROUP BY product_no