Others·Data Scientist·Technical Phone Screen
May 2026
Got a SQL question for a Data Scientist role, one problem, conditional aggregation with quarterly breakdowns. Pretty standard warehouse-style question but the edge case around coins with zero transactions tripped me up a bit.
- Given a coins table and a transactions table, write a SQL query that returns one row per coin with the summed transaction amounts broken out by quarter (Q1 through Q4) for a given year, plus the total transaction count and total amount. Coins with no transactions in that year should still appear with zeros.
“My first instinct was to just filter by year and group by coin, which got me the totals fine.” The rest of the author's notes on Data Scientist interview at Others, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post