Search⌘ K
AI Features

Question: Subquery and Calculations

Explore how to apply subqueries and perform calculations in SQL to analyze product sales data. Learn to write queries that identify products exceeding average sales, improving your ability to handle real-world data analysis tasks.

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

Additional information

You are provided with a table named Products that contains the ...