• Is this homework? What have you tried so far?

    Here's a hint: use GROUP BY and COUNT(*) in a CTE or subquery to find out how many of each product there are, and then use MAX to find out which one has the most.

    John