Thumbtack Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Compare list/dict; parse JSON/CSV at scale
Compare Python list and dict precisely: for append/insert/lookup/update/delete, state average and worst-case time complexity, memory implications, and...
Write monthly new-vs-returning requests SQL
Given the schema and sample data below, write a single PostgreSQL query (no dynamic SQL) that returns, for every calendar month present in requests, t...
Compute weekly 3-week rolling sums in SQL
Using PostgreSQL, write a single query that outputs, for each calendar week in a given range, the sum of amounts in that week and a rolling sum over t...
Write complex joins and window functions
You are given a simplified Thumbtack-like marketplace schema in PostgreSQL. Assume UTC timestamps and weeks start on Monday. Treat "today" as 2025-09-...
Compute weighted response rates by job category
You are given a CSV with one row per job posting and the following columns: job_id, job_category, invitations_sent (integer >= 0), provider_responses ...