Interview question asked to Data Scientists interviewing at Dropbox, StubHub, Rivian and other companies. Original question asked: How would you structure a SQL query to fully optimize Snowflake's micro-partitioning architecture?.