Snowflake interview question

Be prepared to write some SQL. Pretty easy.