I am using the mysql in my job. so, I used function "COALESCE" recently. It's very useful, see the following code. SELECT id, name, COALESCE(phone, 'Not set') AS phone FROM users; Appear "Not set' by default value. We can use "COALESCE" in…