LendingClub interview question

A SQL problem that violates the rule of SQL.