SELECT product_name ,  product_category_code FROM products ORDER BY product_price DESC LIMIT 1
What is the name and category code of the product with the highest price?
SELECT product_name , product_category_code FROM products ORDER BY product_price DESC LIMIT 1
select product_name , product_category_code from products order by product_price desc limit value
What is the name and category code of the product with the highest price ?