First query execution in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

MySQL

SELECT [1] FROM employees;

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

A*

BALL

Ccolumns

Deverything

Attempts:

3 left

💡 Hint

Common Mistakes

Using words like ALL or columns instead of *

Forgetting to specify what to select

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

2fill in blank

medium

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

MySQL

SELECT [1] FROM employees;

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

Aname

Ball

Cnames

Demployee_name

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural or different column names like 'names' or 'employee_name'

Using keywords like 'all' instead of a column name

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

3fill in blank

hard

Fix the error in the query to select the 'salary' column from 'employees'.

MySQL

SELECT [1] FROM employees;

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

Asalaries

Bsal

CSalary

Dsalary

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural or abbreviated column names

Using incorrect capitalization if case-sensitive

The correct column name is 'salary'. Using the exact column name avoids errors.

4fill in blank

hard

Fill both blanks to select the 'name' and 'salary' columns from 'employees'.

MySQL

SELECT [1], [2] FROM employees;

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

Aname

Bsalary

Cage

Ddepartment

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns not in the table

Forgetting the comma between column names

To select multiple columns, list them separated by commas.

5fill in blank

hard

Fill all three blanks to select 'name', 'salary', and 'department' columns from 'employees'.

MySQL

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

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

Aname

Bsalary

Cdepartment

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Including columns not in the table

Missing commas between column names

List all desired columns separated by commas in the SELECT statement.