Shopify·Data Analyst·Technical Phone Screen
- Using only the sessions table, write a SQL query that returns session counts grouped by day, with columns (day, session_count) ordered by day. Handle the timestamp truncation and any timezone concerns appropriately.
“I jumped straight to DATE_TRUNC and felt pretty good about it, but then they asked how I'd handle timezones and I kind of stumbled.”