InterviewDB
Experience
·
Los Angeles
Order Data Analysis - SQL Queries on an E-commerce Orders Schema
phone
Interview Experience
Problem Given the following schema: Write SQL for: Q1: Monthly revenue for the past 12 months, broken down by product category. Q2: Customers who placed orders in every month of the last 6 months (consistently active). Q3: For each customer, their most recent order total and whether it is higher or lower than their average order total. Example output for Q3: Follow-ups How would you optimize Q2 for a table with 50M order rows? Rewrite Q1 using a CTE vs a subquery - which is more readable and why…
Full Details
🔒
Unlock all Sigma Computing questions
Full insider details, leaked discussions, and candidate experiences.
Get full access — $100 a year, unlimited accessAbout This Question
This is a candidate experience report from a sigma computing interview during the phone round.
More Sigma Computing Interview Questions
1p3a
Implementing a Spreadsheet with Custom Column Names at sigmacomputing
1p3a
Sigma Computing Fulltime SDE Tech Phone Screen Interview Experience
1p3a
Sigma Computing Onsite Second Round Interview Experience (USA)
InterviewDB
Sigma Computing SWE Phone - Cell Table
1p3a
Sigma Computing First Round Interview Experience (USA)