All Tasks
Profitable Suppliers Analysis
Show suppliers with total profit over $1000, displaying supplier name, country, and total profit (selling price - cost price).
Reference Tables
Sales
(sales)
| id | quantity | price | sale_date | customer_region | product_id |
|---|---|---|---|---|---|
| 1 | 2 | 1299.99 | Jan. 15, 2024 | North America | 1 |
| 2 | 1 | 129.99 | Jan. 16, 2024 | Europe | 2 |
| 3 | 3 | 89.99 | Jan. 17, 2024 | Asia | 3 |
| 4 | 5 | 19.99 | Jan. 18, 2024 | North America | 4 |
| 5 | 4 | 39.99 | Jan. 19, 2024 | Europe | 5 |
| 6 | 2 | 49.99 | Jan. 20, 2024 | Asia | 6 |
| 7 | 1 | 29.99 | Jan. 21, 2024 | North America | 7 |
| 8 | 1 | 899.99 | Jan. 22, 2024 | Europe | 8 |
| 9 | 6 | 79.99 | Jan. 23, 2024 | Asia | 9 |
| 10 | 1 | 159.99 | Jan. 24, 2024 | North America | 10 |
Products
(products)
| id | product_name | category | supplier_name | cost_price | stock_quantity | supplier_country |
|---|---|---|---|---|---|---|
| 1 | Laptop Pro | Electronics | TechSupply Co | 999.99 | 50 | China |
| 2 | Running Shoes | Sports | SportGear Ltd | 79.99 | 100 | Vietnam |
| 3 | Coffee Maker | Home | HomeAppliances Inc | 59.99 | 75 | Germany |
| 4 | Novel Book | Books | BookWorld Publishers | 12.99 | 200 | USA |
| 5 | Wireless Mouse | Electronics | TechSupply Co | 24.99 | 150 | China |
| 6 | Yoga Mat | Sports | FitnessGear Pro | 29.99 | 80 | India |
| 7 | Cookbook | Books | BookWorld Publishers | 19.99 | 120 | USA |
| 8 | Smartphone | Electronics | MobileTech Inc | 699.99 | 30 | South Korea |
| 9 | Desk Lamp | Home | HomeAppliances Inc | 49.99 | 60 | Germany |
| 10 | Tennis Racket | Sports | SportGear Ltd | 99.99 | 40 | Vietnam |