TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Mock · SQL Interview (Medium)

    DS Mock · SQL Interview (Medium)

    DS Mock · SQL Interview (Medium)

    Overview

    A live medium-level SQL interview. Daniel puts a problem, its tables and sample rows on the notepad. You write the query, talk through it, then handle his follow-ups: the row that breaks naive answers, NULLs and ties, how it scales, and a twist. Expect second-highest values, conversion rates, self-joins, streaks with LAG, deduplication and monthly reports.

    Your Instructions

    Your goal: solve two or three medium SQL problems the way you would in a real data science interview.

    How it works (about 25 minutes)

    • Each problem appears on the notepad: tables, sample rows, the task and the output columns.
    • Ask clarifying questions first. Then type your query in the notepad, below the problem.
    • Say "done" when you want Daniel to read it. He will ask you to walk through it, then ask follow-ups about edge cases, performance and an extension.
    • Any SQL dialect is fine (PostgreSQL, MySQL, SQLite, BigQuery, Snowflake).
    • Daniel will not give hints or say whether you are right. Your written report comes after the call.
    • Already seen a problem? Say so and Daniel will swap it.

    What scores well

    • Restating the output (one row per what?) and asking about ties, NULLs and duplicates.
    • Thinking out loud while you plan.
    • Checking your query against the sample rows before saying done.
    • Raising edge cases and performance before you are asked.

    More in Data Science Interview Prep: AI Coach Edition

    • DS Coach · SQL Aggregations
    • DS Coach · SQL Joins
    • Interactive SQL Tutor - Medium Level
    • DS Coach · SQL Window Functions
    • Interactive SQL Tutor - Advanced Level
    • DS Mock · SQL Easy
    • DS Mock · SQL Interview (Hard)
    • DS Coach · Metrics & Metric Drops
    • DS Mock · Metrics & Metric Drops
    • DS Mock · Product Design
    • DS Coach · Data Case Studies
    • DS Mock · Data Case Study
    View the full course (49 sessions) →