select wife_id from marriages where divorce_date is not NULL;

A bit old, but wow - what a great article! And it's fun to read how table fields are added and removed as the thought process evolves.