#122 · SQL and analytics · 6.6 minSQL Joins: Inner, Left and Anti, With Real Output
Three queries asked which customers have no orders; NOT IN returned 0 rows because of one NULL.
Python 3.12.1514 videos tagged "sqlite".
#122 · SQL and analytics · 6.6 minThree queries asked which customers have no orders; NOT IN returned 0 rows because of one NULL.
Python 3.12.15
#124 · SQL and analytics · 6.6 minA 20-line SQL query builds a cohort retention table; remove DISTINCT and retention shows 150 percent.
Python 3.12.15
#126 · SQL and analytics · 6.8 minOne recursive SQL query finds that Asha has 9 people under her; another goes round a loop until a LIMIT stops it.
Python 3.12.15
#127 · SQL and analytics · 6.6 minSix made-up orders total 220, but two joins make the same SUM say 505, with no error.
Python 3.12.15B was ahead with p 0.015; stopping at the first of ten looks raised false alarms from 4.9 to 17.2 percent.
Python 3.12.15
#134 · SQL and analytics · 6.4 minTwo missing days made SQLite report 156.6 in sales a day for a week that averaged 111.9 once the gaps were filled.
Python 3.12.15Version 3 scored 0.867 against 0.897 in production: the registry refused it, a forced push went through, and one call rolled it back.
Python 3.12.15
#208 · Data governance · 5.8 minI erased a person, a scan found her still in an export, and a restore brought her back.
Python 3.12.15
#238 · Enterprise architecture and AI agents · 5.6 minAfter a crash, my toy agent wrote two replies to the same ticket. The agent was fine.
Python 3.12.15
#246 · Enterprise architecture and AI agents · 5.6 minI asked eight questions to three stores, and each got only its own kind right.
Python 3.12.15Asked one question, a one-table design I built without tenant, version or access columns returned 3 chunks in its top 4 that the user should not get: an old version, another tenant's text, and a note she may not read.
Python 3.12.15On one made-up day, a wide table I wrote to fail could not find the busiest hour, overstated one driver's earnings by 54.18, and gave a surge of 1.0 where the schema said 1.8.
Python 3.12.15
#276 · How it works, by example · 6.5 min200,000 rows: one CREATE INDEX turned a full scan into a search, same answer.
Python 3.12.15
#297 · SQL and analytics · 6.8 minTen SQL queries on one small shop: a left join finds the 1 customer who never ordered.
Python 3.12.15