TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Mock · SQL Interview (Hard)

    DS Mock · SQL Interview (Hard)

    DS Mock · SQL Interview (Hard)

    Overview

    A live hard-level SQL interview. Daniel puts a multi-step problem, its tables and sample rows on the notepad. You settle the definitions, write the query and defend it: ties, gaps, missing months, loops in a hierarchy, how it scales, and a twist. Expect gaps and islands, attribution, month-over-month growth, recursive CTEs, leaderboards with ties and validation rules.

    Your Instructions

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

    How it works (about 25 minutes)

    • Each problem appears on the notepad: tables, sample rows, the task and the output columns.
    • Pin down the definitions first ("first touch", "valid", "growth"). 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

    • Breaking the problem into named steps (one CTE per step) and saying the plan first.
    • Settling ties, gaps and missing rows before you code.
    • 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 Joins
    • Interactive SQL Tutor - Medium Level
    • DS Coach · SQL Window Functions
    • Interactive SQL Tutor - Advanced Level
    • DS Mock · SQL Easy
    • DS Mock · SQL Interview (Medium)
    • DS Coach · Metrics & Metric Drops
    • DS Mock · Metrics & Metric Drops
    • DS Mock · Product Design
    • DS Coach · Data Case Studies
    • DS Mock · Data Case Study
    • DS Mock · ML Coding: KNN & k-means
    View the full course (49 sessions) →