TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Mock · SQL Easy

    DS Mock · SQL Easy

    DS Mock · SQL Easy

    Overview

    A realistic SQL screen. Daniel puts a small schema with sample rows on the notepad, you type your query, then walk him through it. Expect the follow-ups real interviewers ask: what about NULLs, ties, duplicates, the last day of the month? Three easy problems, about twenty-five minutes, with a written report afterwards.

    Your Instructions

    Your goal: solve three easy SQL problems the way a strong candidate does: clarify, write a clean query, walk through it, and handle the edge cases.

    How this works (about 25 minutes)

    • Each problem appears on the notepad: tables, sample rows and the ask.
    • Ask clarifying questions out loud, then type your query below the problem and say "done".
    • Daniel reads it, asks you to walk through it, then asks follow-up questions.
    • No hints and no feedback during the interview. A written report follows.

    Tips

    • Any mainstream SQL dialect is fine. Say which one you are using.
    • Think out loud. State your assumptions.
    • Check your query against the sample rows before you say done.
    • Read the module reading first: SQL Practice: Easy Problems.
    • Taken this mock before? Tell Daniel at the start and he will use different problems.

    More in Data Science Interview Prep: AI Coach Edition

    • Interactive SQL Tutor
    • 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 Interview (Medium)
    • DS Mock · SQL Interview (Hard)
    • DS Coach · Metrics & Metric Drops
    • DS Mock · Metrics & Metric Drops
    • DS Mock · Product Design
    • DS Coach · Data Case Studies
    View the full course (49 sessions) →