String CONCAT

Intermediate

The profile page shows each user's full name in one column: first name, a space, then last name. Some people have only one name (the last_name column is NULL) and must show just their first name, with no trailing space and not a blank value.

Write a query returning one column, full_name.

Constraints

One column named full_name
first_name + space + last_name
If last_name is NULL, return only first_name

Hints

Hint 1

SQL's concatenation operator is ||; SQLite (3.39) has no CONCAT() function.

Hint 2

Concatenating with NULL gives NULL; COALESCE(x, '') swaps NULL for an empty string.

Keywords

SQL

Run your code to see results

No results yet

Run your code to check it against the examples, or submit to run every test.