build1 distinct publisher
The query ran and the number was 38 percent high: reviewing AI-written SQL
A dev.to walkthrough shows a fluent LEFT JOIN double-counting two orders into 1,830 when the right answer was 1,330. The check that catches it costs two statements.
Publishers:dev.to
Reality
- Evidence66
- Adoption
- Insufficient
- Hype gap+14
- Incentives24
- Confidence58