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
List the total scores of body builders in ascending order.
assistant
SELECT Total FROM body_builder ORDER BY Total ASC
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 is the average snatch score of body builders?
assistant
SELECT avg(Snatch) FROM body_builder
human
What are the names of body builders whose total score is higher than 300?
assistant
SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Total > 300
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
What is the average total score of body builders with height bigger than 200?
assistant
SELECT avg ( T1.Total ) FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Height > 200 ;