Technical Screen

Five SQL Questions and a Rehashed User ID Puzzle

GleanData Scientist · Technical Screen · Nov 2025

I haven't seen an interview post about this company, so let me be the first. There were 5 SQL questions, and the interviewer was a DS. The questions themselves weren't that hard, but a lot of the open discussion was pretty tricky. Two tables: users with user_id, signup_date, and login with user_id, browser, date. A few of the questions stuck with me: Calculate login DAU, and if there are days wit…

Shared by a candidate · reported Nov 2025. Interview formats change; use it as a guide, not a script.