SQL FIGHTER

Bad data has invaded the warehouse.

One weapon: the right SQL clause.

Pick the query that defeats each menace. Wrong call, it hits back.