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 is the snatch score of each body builder?
assistant
SELECT Snatch FROM body_builder;
human
What is the minimum value of the them?
assistant
SELECT MIN( Snatch ) FROM body_builder;
human
What about the mean value?
assistant
SELECT AVG ( Snatch ) FROM body_builder ;