Problem Statement

You are given a table products that holds the details of products like ids, names, costs, and categories. Task Write [unclear] query to fetch the names, costs, and [unclear] of the products whose cost is the maximum in their respective categories. Sort the output in decreasing order of the cost, and then in alphabetical order of product name. Note: The numeric values used in the cost column of the sample input table are in USD, For eg; the value 80 implies 80 US Dollars Table description Input format Table: products Field Type Description product_id Integer Represents the unique ID of the products product_name String Represents the name of the products cost Integer Represents the original price of the product category String Represents the category of the product Output format Field Type Description product_name String Represents the name of the [unclear] product_cost Integer Represents the price of the [unclear] product_category String Represents the category name of the product Examp