What are the weights of the body builders?
select t2.weight from body_builder as t1 join people as t2 on t1.people_id = t2.people_id
With those weights, keep the ones whose snatch score is higher 180.
select t2.weight from body_builder as t1 join people as t2 on t1.people_id = t2.people_id where t1.snatch > 180
What about higher than 140 or the height is greater than 200?
select t2.weight from body_builder as t1 join people as t2 on t1.people_id = t2.people_id where t1.snatch > 140 or t2.height > 200;