CONCAT and CONCAT_WS in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

SQL

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

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

Alast_name

B' '

CNULL

Dfirst_name

Attempts:

3 left

💡 Hint

Common Mistakes

Using a space string instead of the last_name column.

Trying to concatenate only one column.

The CONCAT function joins the strings given as arguments. To join first_name and last_name, you need to include last_name as the second argument.

2fill in blank

medium

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

SQL

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 no separator or wrong separator like comma.

CONCAT_WS joins strings with a separator. To add a space between first_name and last_name, 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.

SQL

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

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

A' '

Bcity, state

Ccity + ', ' + state

D', '

Attempts:

3 left

💡 Hint

Common Mistakes

Passing multiple columns as separator.

Using plus signs for concatenation inside CONCAT_WS.

CONCAT_WS requires a single string separator as the first argument. Using ', ' (comma and space inside quotes) correctly separates city and state.

4fill in blank

hard

Fill both blanks to concatenate street, city, and state with ', ' as separator using CONCAT_WS.

SQL

SELECT CONCAT_WS([1], street, [2], state) AS full_address FROM addresses;

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

A', '

Bcity

Cstate

D' '

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong separator like space.

Putting state instead of city in second blank.

CONCAT_WS uses ', ' as the separator. street, city, and state are concatenated with ', ' between them.

5fill in blank

hard

Fill all three blanks to concatenate first_name, middle_name, and last_name with spaces using CONCAT_WS.

SQL

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

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

A' '

Bfirst_name

Cmiddle_name

Dlast_name

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong separator like comma.

Mixing up column order.

CONCAT_WS(' ', first_name, middle_name, last_name) joins the three names with spaces between them.