Snowflake Interview Question

one sql and one modeling