Your task is to obtain the minimum price for each product category. However, to provide customers with options, you need to retrieve only those categories where there are more than 5 different products.

Join two tables, aggregate the data, and use the HAVING clause. At the end, sort the result by the category_name in the ascending order.

Pay attention that in the response, you should have 2 columns: category_name and min_price. So don't forget to set aliases for these columns!

Brief Instructions

• Retrieve the category.name column and the minimum value of the price column from the category table.
• Assign the alias category_name to the first column and min_price to the second.
• Join the product table on the common column category.id = product.category_id.
• Group the data by category.name.
• Use a HAVING clause with the condition COUNT(product.name) > 5.
• Sort the results by category_name.