Snowflake interview question

one sql and one modeling