ByteDance·Data Analyst·Technical Phone Screen
Jun 2026
Bytedance Data Analyst technical screen, two SQL problems back to back. Nothing behavioral, just pure query writing under a bit of time pressure. The problems weren't impossible but the details tripped me up more than I expected.
- Given a users table and a transactions table, identify users whose total completed crypto transaction amount exceeded £100 within the 7 days following their account creation. Return the user ID and that summed amount.
- Using an activity table that logs views and clicks per product, compute the click-through rate for each product and return whichever product (or products) has the highest CTR. Exclude any product that has zero views.
“The window join is where I fumbled a bit.”