You are working for an e$-$ commerce company that wants to track the popularity of products by category. You've been tasked with creating a database view to display the total number of orders placed for each product category. The company needs a way to easily access this information for decision$-$ making and inventory management.

Tables Schema as Below:

Products

columnName dataType

product$\_$id INT

product$\_$name VARCHAR$(255)$

category$\_$id INT

Orders

columnName dataType

order$\_$id INT

product$\_$id INT

quantity INT

Your task is to create a MySQL view named ProductCategoryOrders that displays the total number of orders for each product category. The view should contain the following columns: category$\_$id and total$\_$orders. Order the output by total orders in descending order.

Output