The NULL mistake is that people often write

where a.col = null

instead of

where a.col is null

The multi-row trigger is the same. Developers assume triggers fire once per row, instead of once per transaction. I have examples of why this is an issue.