What's wrong with this SQL DISTINCT hiding duplicate inserts?

What's wrong with this SQL DISTINCT hiding duplicate inserts. The SQL code uses DISTINCT to dedupe. In SQL DISTINCT masks the fact that duplicates were written. In SQL the root cause stays and grows.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqldistinct...

https://www.youtube.com/watch?v=hhCIBFoiC6M

Whats wrong with this SQL DISTINCT hiding duplicate inserts? #sqlmask

YouTube