TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Coach · SQL Joins

    DS Coach · SQL Joins

    DS Coach · SQL Joins

    Overview

    Master SQL joins with Coach Maya. Two tiny tables sit on Maya's live board; you tap your guess for how many rows each join returns, then watch the rows appear. Then you write and run your own queries: members who never visited, a list without duplicates, and a CTE that keeps the zeros. Covers inner, left, right, full outer and cross joins, unions, join fan-out, subqueries and CTEs.

    Your Instructions

    Your goal: know exactly which rows a join keeps, repeats or drops, and say it out loud the way interviewers want to hear it.

    How this works (about 20 minutes)

    • Maya's live board shows two small tables: gym members and their visits.
    • For each join, tap your guess for the row count first. Then the rows appear.
    • Four times you write a query yourself in the board's editor and tap Run. Matching rows turn green; missing rows show as ghosts.
    • Three quick checks along the way: tap your answer on the board.

    Tips

    • Before predicting, ask yourself: what happens to rows with no match?
    • Any SQL dialect is fine. Rough syntax is fine; the logic matters.
    • Read the module reading first: SQL Joins.
    • Interrupt any time to ask a question.

    More in Data Science Interview Prep: AI Coach Edition

    • Tech Interview: Lowest Earning Employees
    • DS Coach · Python for Probability & Simulation
    • DS Mock · Python for Probability & Statistics
    • DS Coach · SQL Basics
    • Interactive SQL Tutor
    • DS Coach · SQL Aggregations
    • 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 Mock · SQL Interview (Hard)
    View the full course (49 sessions) →