L1 Q4
Beginner Level
Practice Question
Level 1 - Question 4: Count Total Number of Orders
Scenario
You're working in the reporting department of an e-commerce platform. Management wants to know how many total orders were placed.
Task
Write a SQL query to count the total number of records in the orders table.
Sample Schema: orders
| order_id | customer_id | order_date | total_amount |
|---|---|---|---|
| 301 | 101 | 2024-01-15 | 520.00 |
| 302 | 102 | 2024-01-20 | 210.00 |
| 303 | 103 | 2024-01-22 | 790.00 |