SFC Data Lab

DATA LAB How this works Explore the Academy

Click any keyword in your query and I'll explain it here, or hit “? Explain” and hover.

Loading engine…

To run your query, click Run or type ⌘ + return

Here's where your results will appear

HARBOR_ROAST.CORE

Harbor Roast Coffee Club, a monthly coffee subscription shipping to all 50 states. Jan 2024 to Dec 2025.

1Learn every table and column first 2Then pick the ones your analysis needs

SQL Glossary

Assignmentsanswers included

1 · Economic nexusWhich states crossed $100k in cumulative taxable sales, and in which filing month did each cross the line?

2 · CAC paybackBy acquisition channel, build monthly signup cohorts and find the month where cumulative revenue per customer surpasses that channel's CAC.

3 · Ghost customersSome customers subscribed but cancelled before their first shipment, so they never appear in orders. Using a LEFT JOIN, find every customer with zero orders: how many are there in total and per acquisition channel?

Stuck? Copy the schema and draft your SQL with an LLM.

Unlock the answers

Check your inbox