I bravely ordered the soup that was glowing a mysterious shade of neon green.
The waiter, who had clearly never balanced a tray before, immediately dropped the bowl right onto my lap.

Use that for defining relative clauses about things (like soup). Who and whom are only used for people.

Use who for non-defining relative clauses about people. You cannot use that immediately after a comma in a non-defining relative clause.