COALESCE It is used to check if the argument is NULL, if it is NULL then it    takes the default value. It will check for NOT NULL values