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
What are the heights of the people?
assistant
SELECT Height FROM people;
human
What is the average?
assistant
SELECT AVG ( Height ) FROM people;
human
What are the heights of the body builders?
assistant
SELECT T2.Height FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID;
human
For those results, which ones have weight larger than 91.0?
assistant
SELECT T2.Height FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Weight > 91.0 ;