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
What are the names of body builders in descending order of total scores?
assistant
SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Total DESC
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 are the birthdays of people in ascending order of height?
assistant
SELECT Birth_Date FROM People ORDER BY Height ASC
human
List the height and weight of people in descending order of height.
assistant
SELECT Height , Weight FROM people ORDER BY Height DESC ;