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 body builders with total score smaller than 315?
assistant
SELECT T2.Height FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Total < 315
human
List the weight of the body builders who have snatch score higher than 140 or have the height greater than 200.
assistant
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;
human
What are the clean and jerk score of the body builder with the highest total score?
assistant
SELECT Clean_Jerk FROM body_builder ORDER BY Total DESC LIMIT 1
human
List the snatch score and clean jerk score of body builders in ascending order of snatch score.
assistant
SELECT Snatch , Clean_Jerk FROM body_builder ORDER BY Snatch ASC
human
What is the average snatch score of body builders?
assistant
SELECT avg(Snatch) FROM body_builder
human
What is the minimum snatch score?
assistant
SELECT MIN( snatch ) FROM body_builder ;