Store Overview & Orders
Demonstrates reading records from MySQL using SQL JOIN statements and aggregate functions.
Total Revenue
$319.47
Total Orders
3
Products Count
6
Low Stock Alert
1
Customer Orders (3)
| Order ID | Customer | Item Purchased | Qty | Total Price | Status | Date | |
|---|---|---|---|---|---|---|---|
| #3 | Michael Brown | mbrown@example.com | Ultra-Slim Mechanical Keyboard | 1 | $89.50 | Processing | Aug 07, 2026 - 18:21 |
| #2 | Sarah Smith | sarah.s@example.com | Smart Fitness Tracker Watch | 2 | $99.98 | Completed | Aug 07, 2026 - 18:21 |
| #1 | Alex Johnson | alex.j@example.com | Pro Noise-Canceling Headphones | 1 | $129.99 | Completed | Aug 07, 2026 - 18:21 |
Current Inventory
| ID | Product Name | Category | Unit Price | Current Stock | Stock Status |
|---|---|---|---|---|---|
| #6 | Portable Desk LED Lamp | Accessories | $29.99 | 5 units | Low Stock |
| #2 | Ultra-Slim Mechanical Keyboard | Peripherals | $89.50 | 8 units | In Stock |
| #3 | Minimalist Leather Backpack | Accessories | $65.00 | 12 units | In Stock |
| #1 | Pro Noise-Canceling Headphones | Audio | $129.99 | 15 units | In Stock |
| #4 | Smart Fitness Tracker Watch | Wearables | $49.99 | 20 units | In Stock |
| #5 | High-Precision Ergonomic Mouse | Peripherals | $34.95 | 25 units | In Stock |