Understanding COUNT() in Snowflake:

When you write queries in Snowflake, you may come across different ways of using COUNT.