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

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" "T1" JOIN "people" "T2" ON "T1"."People_ID" = "T2"."People_ID"