Why SELECT is the most important command in SQL - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

SQL

SELECT [1] FROM employees;

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

A*

BALL

CEVERY

DCOLUMNS

Attempts:

3 left

💡 Hint

Common Mistakes

Using words like ALL or COLUMNS instead of * causes errors.

Leaving the blank empty will cause a syntax error.

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

2fill in blank

medium

Complete the code to select only the 'name' column from the 'students' table.

SQL

SELECT [1] FROM students;

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

Anames

Bname

Cstudent_name

Dall_names

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural or different column names that don't exist.

Using reserved words or made-up names.

Use the exact column name 'name' to select that column.

3fill in blank

hard

Fix the error in the code to select the 'age' column from the 'users' table.

SQL

SELECT [1] FROM users;

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

Aage

Buser_age

Cages

DAge

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural or different column names.

Capitalizing column names when not needed.

The correct column name is 'age'. Using 'ages' or 'user_age' will cause errors.

4fill in blank

hard

Fill both blanks to select the 'id' and 'email' columns from the 'contacts' table.

SQL

SELECT [1], [2] FROM contacts;

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

Aid

Bemail

Cname

Dphone

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns that don't exist in the table.

Forgetting the comma between column names.

To select multiple columns, list them separated by commas. Here, 'id' and 'email' are the correct columns.

5fill in blank

hard

Fill all three blanks to select 'product_name', 'price', and 'stock' columns from the 'inventory' table.

SQL

SELECT [1], [2], [3] FROM inventory;

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

Aproduct_name

Bprice

Cstock

Dquantity

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column names like 'quantity' instead of 'stock'.

Missing commas between column names.

List the exact column names separated by commas to select multiple columns.