WorksheetsSQL Exercise #1
Total questions: 10
Worksheet time: 10mins
Name
Class
Date
1.
What is the total revenue generated from all orders?
(a)
2.
How many products are currently in stock?
(a)
3.
What is the most expensive product in stock? and its price?
answer example
product_name, price
(a)
4.
How many customers are from the USA?
(a)
5.
Show the "CustomerNumber" that has the most orders
(a)
6.
How many products have total revenue of more than 100.000?
(a)
7.
How many customers have a contact last name starting with 'S'?
(a)
8.
What month had the highest total orders in 2003?
(a)
9.
How many orders are successfully completed each year?
Example Answer
2003=100, 2004=50, 2005=30
(a)
10.
Categorize products based on their price range (Low, Medium, High). What type of product is "S10_4962"? choose between low, medium or high.
a)
low
b)
medium
c)
high
100 %
