For this question, use the track table in the PostgreSQL database for this course.

Suppose you have written the following query:

SELECT name, composer FROM track;

The problem with it is that some records have a null value for composer.

How would you modify this query to insert $$Unknown$$ into the composer column in place of null values?

launch database

A$.)$

SELECT name, composer,

COALESCE $($composer$,$ 'Unknown'$)$

AS composer

FROM track;

B$.)$

SELECT name,

COALESCE $($composer$,$ 'Unknown'$)$

AS composer

FROM track;

C$.)$

SELECT

COALESCE $($composer$,$ 'Unknown'$)$

AS composer

FROM track;

D$.)$

SELECT name,

COALESCE composer, 'Unknown'

AS composer

FROM track;