Oracle : NVL SQLite : ifnull ifnull(X,Y) Return a copy of the first non-NULL argument. If both arguments are NULL then NULL is returned. The ifnull() functions and coalesce() with two arguments are interchangeable. SQLite Query Language: C…