Onsite

SQL Screen Then a Four-Round Onsite Full of Case Studies

UpstartData Scientist · Onsite · Oct 2025

Three SQL questions, no need to actually run the query. There's a marketing table (by marketing_touch), and another one is a conversion table. The first question is to calculate avg count by month. The second is to find the last touch before conversion, by company (or by month, I don't quite remember). The third is: conversion and last touch both happened in some particular month, and how many co…

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