Question: Subquery and Calculations
Learn how to use subqueries.
We'll cover the following...
Question
Given the following Products
table structure:
Products
ProductID | ProductName | Category | Price | UnitsSold |
1 | Smartphone | Electronics | 599.99 | 100 |
2 | Laptop | Electronics | 999.99 | 50 |
3 | Headphones | Electronics | 149.99 | 75 |
4 | T-shirt | Apparel | 19.99 | 200 |
5 | Jeans | Apparel | 39.99 | 150 |
6 | Running Shoes | Footwear | 79.99 | 100 |
7 | Bagpack | Accessories | 49.99 | 80 |
...