Chapter 69 of 1962 min read
Lesson 7.3 — HAVING: Filtering Groups, Not Rows
🧬 Biological Scenario: "Show me only genes with average expression above 10 TPM" filters on the result of an aggregate — can't do this, since filters individual rows before grouping happens. 💻 SQL Code Lab: 🔍 Query…
Sign in to read this
“Lesson 7.3 — HAVING: Filtering Groups, Not Rows” is for subscribers. Start with a free account — it takes a name and an email — then subscribe for $1 a month to open it.
- Python and R courses free in full
- First two chapters of every other course