How to Use Coalesce in Snowflake

Imagine you're looking at a Snowflake integer column where some rows are null:

select day, tickets
from stats;
    day     | tickets
------------+---------
 2020-05-01 | 1
 2020-05-02 | null
 2020-05-03 | 3

Instead of having that null, you might want that row to be 0. To do that, use the coalesce() function, which returns the first non-null argument it's passed:

select day, coalesce(tickets, 0)
from stats;
    day     | tickets
------------+---------
 2020-05-01 | 1
 2020-05-02 | 0
 2020-05-03 | 3
Cta

SQL editing that just rocks

PopSQL and Snowflake, better together