CONCAT and CONCAT_WS in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to concatenate first_name and last_name without any separator.

MySQL

SELECT CONCAT(first_name [1] last_name) AS full_name FROM employees;

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

A||

B+

C,

D&

Attempts:

3 left

💡 Hint

Common Mistakes

Using + or || instead of comma inside CONCAT.

Trying to concatenate without commas.

The CONCAT function in MySQL takes multiple arguments separated by commas and joins them into one string.

2fill in blank

medium

Complete the code to concatenate first_name and last_name with a space between them using CONCAT_WS.

MySQL

SELECT CONCAT_WS([1], first_name, last_name) AS full_name FROM employees;

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

A' '

B','

C'-'

D''

Attempts:

3 left

💡 Hint

Common Mistakes

Using CONCAT instead of CONCAT_WS for separator.

Using wrong separator like '-' or ',' instead of space.

CONCAT_WS joins strings with a separator as the first argument. To add a space, use ' ' as the separator.

3fill in blank

hard

Fix the error in the code to concatenate city and state with a comma and space using CONCAT_WS.

MySQL

SELECT CONCAT_WS([1], city, state) AS location FROM addresses;

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

A' , '

B';'

C','

D', '

Attempts:

3 left

💡 Hint

Common Mistakes

Using ' , ' with spaces around comma inside quotes.

Using only ',' without space.

Using wrong separator like ';'.

The separator should be a comma followed by a space: ', ' (with no extra spaces inside quotes).

4fill in blank

hard

Fill both blanks to concatenate first_name, middle_name, and last_name with spaces, skipping NULL middle_name.

MySQL

SELECT CONCAT_WS([1], first_name, [2], last_name) AS full_name FROM employees;

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

A' '

Bmiddle_name

CNULL

DmiddleName

Attempts:

3 left

💡 Hint

Common Mistakes

Using NULL instead of middle_name column.

Using wrong separator like comma.

Using wrong column name like middleName.

CONCAT_WS uses the first argument as separator (space here). Middle_name is the column to include, and CONCAT_WS skips NULL values automatically.

5fill in blank

hard

Fill all three blanks to concatenate street, city, and zip code separated by commas and spaces.

MySQL

SELECT CONCAT_WS([1], street, [2], [3]) AS address FROM locations;

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

A', '

Bcity

Czip_code

Dstate

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong separator like ';'.

Using wrong column names like state instead of zip_code.

Missing commas or spaces in separator.

Use ', ' as separator. Include city and zip_code columns in order to form full address.