Question

How can we apply COALESCE() function on a MySQL table’s data value?

Answer 1

if the value in the state column is NULL, the COALESCE function will substitute it by the N/A string. Otherwise, it returns the value of the state column. Another typical example of using the COALESCE function is to substitute value in one column by another when the first one is NULL.

.

.

.

.

.

plz mark me as brainliest.