Select coalesce(sal ,2)+100 as sal from tablename. What is the meaning of above query

Answer 1

coalesce check if sal is null. If It's null, the value 2 is evaluated. Then the result is 102

if sal isn't null is added to 100

Answer 2

Furthermore 'sal' probably means salary 😁