Free account

Save your progress

Keep your skill report, learning progress and passport safe, and pick up on any device.

  • Report updates after every test
  • Learning progress on every device
  • Reserve your passport link
or with email
Free forever. No card. Your scores stay private unless you choose to share them.
Learn data analyticsModule 3 of 4 · 0 done
  1. Asking good questions of data
  2. Spreadsheets & cleaning data
  3. SQL & statistical thinking
  4. Visualisation & data storytelling
Module 3 of 4 · SQL · 35 min

SQL & statistical thinking

Query with SELECT, JOIN, GROUP BY and window functions — and reason about averages, variation and causation.

By the end you’ll be able to

  • Write joins and aggregations
  • Use a window function
  • Avoid common statistical traps

SQL in five clauses

SELECT what, FROM where, WHERE which rows, GROUP BY how to bucket, ORDER BY how to sort. JOINs combine tables on keys; LEFT JOIN keeps every row from the left table. Window functions (ROW_NUMBER, SUM OVER) compute across rows without collapsing them.

  • Check row counts after every join
  • Use CTEs (WITH) to keep queries readable
  • COUNT(DISTINCT …) for unique users

Averages lie

Means are pulled by outliers; medians aren’t. Always look at the distribution. Report variation (ranges, percentiles) along with central values.

Correlation is not causation

Two things moving together may share a cause or be coincidence. Only randomised experiments (or careful quasi-experiments) support causal claims. Watch for Simpson’s paradox when segments disagree with the total.

Practical exercise

Answer your plan with SQL

Load your dataset into a free SQL playground (SQLite online, BigQuery sandbox).

0/5 steps

Deliverable: Queries with results and a short findings note. Add it to your skills passport as a project when it’s done.

Checkpoint

Check your understanding

Answer 3 scenario questions. Get 2 or more right to complete the module.

1. Which keeps all rows from the first table?
2. Salaries with a few very high earners: which summary is most typical?
3. Ice-cream sales and drownings rise together. The best explanation?
Measure it

See how your sql scores

A free test adds SQL to your skill report and shows how close you are to the 75% job-ready target.

Go deeper

Free PDF · 74 pages · 2 editions

The Laws of UX, in one field guide

60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.

Pick your edition
Free PDF · 74 pages

Get Laws of UX by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy

Free PDF · 90 pages · 2 editions

100+ Subscription Paywalls, decoded

110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.

  • 110 paywalls rated
  • 34 Laws of UX
  • 12 frameworks

Which paywall scored 4.8 out of 5, and which scored 2.6? It’s all inside.

Pick your edition
Free PDF · 90 pages

Get 100+ Paywalls, Decoded by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy