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