sql query help

hi peeps

i have a table set up

table: orderitems
orderid
productid
qty

is there anyway of listing productid of items ordered x times?

i have managed to get basic things working but found no reference to this and not sure if the set up of my database would allow such a query

cheers :)

--
get me tools and beer