Write a SQL query to find the total number of orders made by each customer, sorted...

Transcribed Image Text:

Write a SQL query to find the total number of orders made by each customer, sorted in descending order by the total number of orders. Example: Input: Order table: order_id 1 2 3 4 5 6 Output: customer_id 2 3 1 Query: customer_id 1 2 1 3 2 3 total_orders 22 19 2 SELECT customer_id, COUNT(*) AS total_orders FROM Order GROUP BY customer_id ORDER BY total_orders DESC Copy code Write a SQL query to find the total number of orders made by each customer, sorted in descending order by the total number of orders. Example: Input: Order table: order_id 1 2 3 4 5 6 Output: customer_id 2 3 1 Query: customer_id 1 2 1 3 2 3 total_orders 22 19 2 SELECT customer_id, COUNT(*) AS total_orders FROM Order GROUP BY customer_id ORDER BY total_orders DESC Copy code

Answer rating: 100% (QA)

The detailed ... View the full answer