TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Coach · SQL Window Functions

    DS Coach · SQL Window Functions

    DS Coach · SQL Window Functions

    Overview

    Learn SQL window functions with Coach Maya. Two small tables sit on Maya's live board: team scores with a tie, and daily orders. You tap a prediction, then watch a frame walk down the rows. Then you write and run your own queries: team bests, rank within a team, second place per team, day-over-day change. Quick checks on how RANK, DENSE_RANK and ROW_NUMBER handle ties.

    Your Instructions

    Your goal: pick the right window function for rankings, change over time and running totals, and explain how it treats ties.

    How this works (about 20 minutes)

    • Maya's live board shows two small tables: player scores and daily orders.
    • You tap your prediction first, then the rows appear and the window frame walks through them.
    • 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, all about ties: tap your answer on the board.

    Tips

    • Before writing OVER, say the partition and the order out loud.
    • Any SQL dialect is fine. Rough syntax is fine; the logic matters.
    • Read the module reading first: SQL Window Functions.
    • Interrupt any time to ask a question.

    More in Data Science Interview Prep: AI Coach Edition

    • DS Mock · Python for Probability & Statistics
    • DS Coach · SQL Basics
    • Interactive SQL Tutor
    • DS Coach · SQL Aggregations
    • DS Coach · SQL Joins
    • Interactive SQL Tutor - Medium Level
    • Interactive SQL Tutor - Advanced Level
    • DS Mock · SQL Easy
    • DS Mock · SQL Interview (Medium)
    • DS Mock · SQL Interview (Hard)
    • DS Coach · Metrics & Metric Drops
    • DS Mock · Metrics & Metric Drops
    View the full course (49 sessions) →