What are the ids of the males who had a wedding?
select male_id from wedding
Show all the male people who have not had a wedding.
select * from people where is_male = 'T' and people_id not in (select male_id from wedding)
What are their names and ages?
select name, age from people where is_male = 'T' and people_id not in (select male_id from wedding)