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 all the information about the body builders?
assistant
SELECT * FROM body_builder;
human
Which have the top three total score?
assistant
SELECT * FROM body_builder ORDER BY Total DESC LIMIT 3;
human
What about top one?
assistant
SELECT * FROM body_builder ORDER BY Total DESC LIMIT 1 ;