Is Coalesce a function of ANSI SQL
Yes:
https://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server/
From the article:
Some think that you need to use COALESCE because it is the only one that adheres to the ANSI SQL standard.
and Yes.