List the item number description unit price and category for

List the item number, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category GME. Use either the ALL or ANY operator in your query.

Solution

SELECT ITEM_NUM, DESCRIPTION, PRICE, CATEGORY

FROM ITEM

WHERE PRICE > ANY (

SELECT PRICE

FROM ITEM

WHERE CATEGORY = \'GME\'

);