Glossary: SQL Beyond the Basics
Fan-out
Also written: double counting
Rows repeated by joining to a table with several matches per row. Joining order_items makes Bloom Café's order appear once per line, so COUNT(*) overcounts orders.
Glossary: SQL Beyond the Basics
Also written: double counting
Rows repeated by joining to a table with several matches per row. Joining order_items makes Bloom Café's order appear once per line, so COUNT(*) overcounts orders.