SQL Exercise #1

SQL Exercise #1

Assessment

Quiz

Information Technology (IT)

Professional Development

Practice Problem

Hard

Created by

Bayu Prasetya

Used 1+ times

FREE Resource

Student preview

quiz-placeholder

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?