What are the names of all the people?
select name from people
Show the names of body builders.
select t2.name from body_builder as t1 join people as t2 on t1.people_id = t2.people_id
Among those, which total score is higher than 200?
select t2.name from body_builder as t1 join people as t2 on t1.people_id = t2.people_id where t1.total > 200
What about higher than 300?
select t2.name from body_builder as t1 join people as t2 on t1.people_id = t2.people_id where t1.total > 300