
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 BLANK QUESTION
1 min • 1 pt
What is the total revenue generated from all orders?
2.
FILL IN THE BLANK QUESTION
1 min • 1 pt
How many products are currently in stock?
3.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What is the most expensive product in stock? and its price?
answer example
product_name, price
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
How many customers are from the USA?
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Show the "CustomerNumber" that has the most orders
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
How many products have total revenue of more than 100.000?
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
How many customers have a contact last name starting with 'S'?
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?