Question

Given the following 'orders' table:
```
| order_id | customer_id | order_date |
|----------|-------------|------------|
| 1        | 1001        | 2022-01-10 |
| 2        | 1002        | 2022-01-11 |
| 3        | 1001        | 2022-01-12 |
```
Which SQL query counts the number of orders placed by customer 1001?

Accepted Answer

SELECT COUNT(*) FROM orders WHERE customer_id = 1001;

Answer

SELECT COUNT(*) FROM orders WHERE order_id = 1001;

Answer

SELECT COUNT(order_id) FROM orders WHERE customer_id = 1001;

Answer

SELECT COUNT(customer_id) FROM orders WHERE customer_id = 1001;

Question from the SQL - Fundamentals test