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 snatch scores of each body builder?
assistant
SELECT Snatch FROM body_builder;
human
What are the snatch score and clean jerk score of each body_builder?
assistant
SELECT Snatch , Clean_Jerk FROM body_builder;
human
Order the results in ascending order of snatch score.
assistant
SELECT Snatch , Clean_Jerk FROM body_builder ORDER BY Snatch ASC ;