CREATE TABLE people (Name VARCHAR, People_ID VARCHAR)
CREATE TABLE body_builder (People_ID VARCHAR)

What are the names of body builders?
SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID
SELECT "T2"."Name" FROM "body_builder" AS "T1" JOIN "people" AS "T2" ON "T1"."People_ID" = "T2"."People_ID"