Show the organization whose name is "Labour Party".
select * from organizations where organization_name = "Labour Party"
What are the contact individuals for this organization?
select * from organizations as t1 join organization_contact_individuals as t2 on t1.organization_id = t2.organization_id join individuals as t3 on t2.individual_id = t3.individual_id where t1.organization_name = "Labour Party"
Of these, find the last name of the latest contact individual.
select t3.individual_last_name from organizations as t1 join organization_contact_individuals as t2 on t1.organization_id = t2.organization_id join individuals as t3 on t2.individual_id = t3.individual_id where t1.organization_name = "Labour Party" order by t2.date_contact_to desc limit 1