Skip to content
Waypoint

Course studio

Welcome back, Ana

Window functions for analysts still has 14 lessons as the studio drafted them. Your October payout stands at $9,475 and lands on Nov 15.

Draft a new courseView public profile

Ana Reyes

View public profile

Overview

Oct 1–22

Learners

2,071

+4% on September

Course sales

143

+6% on September

Rating

4.8

12,410 ratings

Drafts

3
New draftDraft a new course

October payout

Lands Nov 15

$9,475.20

Oct 1524 days to go

Your 70% of 143 course sales, and 43,650 Plus minutes.

Step 1 · Outline

One line becomes six chapters you rewrite

Describe the course as you would to a colleague. The studio orders six chapters by what depends on what, and a lesson you leave as drafted publishes with an AI drafted badge.

Nothing is recorded or published from this board.

Lesson length
Try

Open draft

Window functions for analysts

6 chapters · 22 lessons · 4 h 33 min · Intermediate

  • In your words8
  • As drafted14
All changes saved
  1. 01

    36 min · 3 lessons

  2. 02

    49 min · 4 lessons

  3. 03

    51 min · 4 lessons

  4. 04

    36 min · 3 lessons

  5. 05

    52 min · 4 lessons

  6. 06

    49 min · 4 lessons

Step 2 · Recording

Record once. The studio finds where each lesson starts.

Upload the module as one recording. The studio reads the transcript for where each idea ends and the next begins, then leaves each cut for you to keep, move or take out.

A bright desk set up to record: a microphone on a stand, a monitor with a webcam on top, headphones on a stand and a palm by the wall
Module 4 · take 21:01:48
14:55

Lessons found

4

Transcript

Lesson 4.1 · 14:55

  13. Cut 1 · 15:58

    The talk turns from inner joins to the rows a left join keeps.

  25. Cut 2 · 31:47

    A new question starts: March revenue by category.

  37. Cut 3 · 46:51

    You go back to the forty-six rows the last join added.

Cuts

3

3 cuts wait for you before the module can be published.

Step 3 · Quiz

Every question names the minute it comes from

The studio cuts questions from what the take says, and each points to the line it came from. None reaches a learner before you approve it.

Questions

From the transcript of module 4, take 2.

Question 1 of 5

An inner join from orders to customers returns 96 fewer March rows than orders holds. Why?

  1. The guest checkouts match no customerAnswer
  2. Repeat customers are merged into one row
  3. The join skips the last day of the month

Why: A NULL customer_id matches no customer, so an inner join leaves the guest checkouts out.

0 of 5 approved

Revenue

What each course paid you, month by month

Every sale pays you 70% of its price, and every minute a Plus subscriber watches pays $0.042 at last month's rate. Both land on the 15th of the month after.

October payout

so far
Lands Nov 15

$9,475.20

From sales
$7,641.90
143 sales
From Plus
$1,833.30
43,650 minutes

24 days to goA month under $50 rolls into the next.

Last 12 months

$127,497

  • Sales
  • Plus

October, so far

By course

October

Pick one to see its months alone.

Plus minutes

43,650

Watched in October so far

$0.042 a minute last monthHow Plus pays

Statements

  • September 2026Paid Oct 15$12,684
  • August 2026Paid Sep 15$11,910
  • July 2026Paid Aug 15$10,831
  • June 2026Paid Jul 15$10,873