Database: customer_complaints
Question: What is the name and category code of the product with the highest price?
SQL:
SELECT product_name ,  product_category_code FROM products ORDER BY product_price DESC LIMIT 1