[Solved] Given the table orders with columns customer_id and order_total, what will this query return?SELECT customer_id, COUNT(*) AS order_count FROM orders GROUP BY customer_id ORDER BY order_count ASC; | SQL

SQL - GROUP BY and HAVING

Given the table orders with columns customer_id and order_total, what will this query return?

SELECT customer_id, COUNT(*) AS order_count FROM orders GROUP BY customer_id ORDER BY order_count ASC;

ASyntax error due to incorrect ORDER BY usage.

BList of customers with their order counts sorted from highest to lowest.

CList of customers with total order amounts sorted ascending.

DList of customers with their order counts sorted from lowest to highest.

Step-by-Step Solution

Solution:

Step 1: Understand the GROUP BY and COUNT
The query groups rows by customer_id and counts orders per customer.
Step 2: Analyze ORDER BY order_count ASC
Ordering by order_count ascending sorts customers from fewest to most orders.
Final Answer:
List of customers with their order counts sorted from lowest to highest. -> Option D
Quick Check:
ORDER BY ASC sorts ascending [OK]

Quick Trick: ORDER BY ASC sorts from smallest to largest [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table orders with columns customer_id and order_total, what will this query return?