SQL Exercise #1
Authored by Bayu Prasetya
Information Technology (IT)
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What is the total revenue generated from all orders?
(a)
2.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
How many products are currently in stock?
(a)
3.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
What is the most expensive product in stock? and its price?
answer example
product_name, price
(a)
4.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
How many customers are from the USA?
(a)
5.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Show the "CustomerNumber" that has the most orders
(a)
6.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
How many products have total revenue of more than 100.000?
(a)
7.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
How many customers have a contact last name starting with 'S'?
(a)
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
