Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
The COALESCE() function
6. Using COALESCE() with other functions
The GREATEST() & LEAST() functions
The NULLIF() function
Summary

## Instruction

Nice! You can also use COALESCE() with other functions and operations, such as concatenation, multiplication, etc. Take a look:

SELECT
COALESCE(category, 'unknown category')
|| ': '
|| COALESCE(type, 'unknown type')
AS category_type
FROM product;

In the above query fragment, a NULL category or type value is replaced with an appropriate message, but we can still see the type when the category is NULL (and vice versa).

## Exercise

Show the following sentence:

Product X is made in Y.

X is the product name and Y is the production area. If the product name is not provided, display 'unknown name' instead. If the production area is not provided, substitute 'unknown area'. Name the column origin.

### Stuck? Here's a hint!

Use the operator || to create the sentence. Remember the period/full stop.