Write SQL for session analytics
Company: Shopify
Role: Data Engineer
Category: Coding & Algorithms
Difficulty: easy
Interview Round: Technical Screen
Overview: This question evaluates SQL proficiency and data engineering competencies, including deduplication, joins, time-series aggregation, rolling-window calculations, calendar generation, and URL query-parameter extraction.
Read the full Shopify Data Engineer interview experience this question came from
