Meta interview question

What is 19+NULL in SQL

Interview Answers

Anonymous

18 Jun 2020

Null

Anonymous

7 Oct 2020

For Postgres, Redshift & BigQuery: If this is a sum of rows for a column where 1 row is 19 and 1 row is null then the answer is 19. If this is straight up "Select 19 + null" then it's null