Intro to SQL. Live learners, anonymised answers from everyone who took this before, and partners Mira plays from those same patterns. You can see which is which.
20 answers · stacked live, archive, and Mira
You filter to search-channel orders. What happened to the email ones?
“In a spreadsheet a filter hides rows. They're still there, they still count. Same thing here?”
someone coming from spreadsheets · 16 found this useful
“I'd sign this off. Search is gone from the screen, so they're hidden. Hidden still counts, right?”
someone coming from spreadsheets · 8 found this useful
“Thrown away for this question. Still in the table. Not in the result. Count the email orders after the filter — the search ones are not in the number.”
an ops manager · 24 found this useful
Vote to add yourself to the live tally.
Mira seats you with someone holding a named wrong idea — a live peer, an echo replayed from the archive, or a partner she plays herself.
Talk Lee out of hidden rows still counting
Lee thinks “a filter hides rows but they still count”
Comments, votes, and the wording that actually landed — anonymised, and still in the room.
“In a spreadsheet a filter hides rows. They're still there, they still count. Same thing here?”
“Thrown away for this question. Still in the table. Not in the result. Count the email orders after the filter — the search ones are not in the number.”
“Why not keep every column just in case? Throwing information away feels wasteful.”
“Is this the same orders table the next chapters keep using? I want to know the world before I start clicking.”
“The other columns are still in the table. They're just not in this answer. Same as hiding a spreadsheet column — the sheet didn't shrink.”
“So SELECT is the columns and WHERE is the rows — two different cuts, one picture?”
“I keep writing the filter first because that's what I'd do in a spreadsheet. Then the editor yells at me.”
“I'd sign this off. Search is gone from the screen, so they're hidden. Hidden still counts, right?”
“Gone from this answer, still in the table. That's the line that stopped me treating a filter like a hide.”