Order the product records by descending price.
select * from products order by product_price desc
Just show the product names and category codes.
select product_name, product_category_code from products order by product_price desc
Only for the most expensive product.
select product_name, product_category_code from products order by product_price desc limit 1