gistfile1.txt

select distinct people.id as peopleID, people.name from people where id in 
(select distinct peopleid from results where competitionid in 
(select id from competitions where held >= '2002-06-01'::date and held < '2002-07-01'::date)) 
or id in (select distinct peopleid from results where sportid = (select id from sports where name = 'High Jump') 
and result = (select record from sports where name = 'High Jump')) order by people.name;