What is a database in SQL - Interactive Quiz & Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the table named 'users'.

SQL

SELECT [1] FROM users;

Drag options to blanks, or click blank then click option'

AEVERY

B*

CALL

DALL_COLUMNS

Attempts:

3 left

💡 Hint

Common Mistakes

Using words like ALL or EVERY instead of the symbol *.

Trying to write column names when you want all columns.

The asterisk (*) means to select all columns from the table.

2fill in blank

medium

Complete the code to find the names of all customers from the 'customers' table.

SQL

SELECT [1] FROM customers;

Drag options to blanks, or click blank then click option'

Aaddress

Bphone

Cname

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting columns unrelated to the question like age or phone.

Using * when only names are needed.

We want to get the 'name' column from the customers table.

3fill in blank

hard

Fix the error in the code to select all records from the 'orders' table.

SQL

SELECT [1] orders;

Drag options to blanks, or click blank then click option'

AJOIN

BINTO

CWHERE

DFROM

Attempts:

3 left

💡 Hint

Common Mistakes

Using INTO or WHERE instead of FROM.

Omitting the keyword before the table name.

The keyword FROM is needed to specify the table to select from.

4fill in blank

hard

Fill both blanks to select the 'email' column from the 'subscribers' table where the status is 'active'.

SQL

SELECT [1] FROM subscribers WHERE status [2] 'active';

Drag options to blanks, or click blank then click option'

Aemail

B=

C!=

DLIKE

Attempts:

3 left

💡 Hint

Common Mistakes

Using '!=' or 'LIKE' instead of '=' in the WHERE clause.

Selecting the wrong column.

Select the 'email' column and use '=' to filter rows where status is 'active'.

5fill in blank

hard

Fill all three blanks to select the 'product' and 'price' columns from 'inventory' where quantity is greater than 10.

SQL

SELECT [1], [2] FROM inventory WHERE quantity [3] 10;

Drag options to blanks, or click blank then click option'

Aproduct

Bprice

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' in the WHERE clause.

Selecting wrong columns or missing one.

Select 'product' and 'price' columns and filter rows where quantity is greater than 10 using '>'.