Welcome to the forum. I'd suggest looking up the Min & Max functions. You'll probably need Count function to get the number of orders for each product as well. Good place to start would be http://www.techonthenet.com/sql/min.php Do a bit of digging and then come back with more details of exactly what you want the output to be if you get stuck.
