SQL Exercise #1

What is the total revenue generated from all orders?

How many products are currently in stock?

What is the most expensive product in stock? and its price?

answer example

product_name, price

How many customers are from the USA?

Show the "CustomerNumber" that has the most orders

How many products have total revenue of more than 100.000?

How many customers have a contact last name starting with 'S'?

What month had the highest total orders in 2003?

How many orders are successfully completed each year?

Example Answer

2003=100, 2004=50, 2005=30

Categorize products based on their price range (Low, Medium, High). What type of product is "S10_4962"? choose between low, medium or high.

• low

• medium

• high