human
Schema:
body_builder (Body_Builder_ID, People_ID, Snatch, Clean_Jerk, Total)
people (People_ID, Name, Height, Weight, Birth_Date, Birth_Place)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi there! Can you show me a list of all body builder names and their associated birth dates?
assistant
SELECT T2.name , T2.birth_date FROM body_builder AS T1 JOIN people AS T2 ON T1.people_id = T2.people_id;
human
Could you filter this list to show only the rows which are associated with body builders whose birthday value contains the work 'January'?
assistant
SELECT T2.name , T2.birth_date FROM body_builder AS T1 JOIN people AS T2 ON T1.people_id = T2.people_id WHERE T2.Birth_Date LIKE '%January%';
human
Great! Can you tell me where Jack Campbells birthplace was?
assistant
SELECT birth_place FROM people WHERE name = "Jack Campbell" ;