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 birthdays of people in ascending order of height?
assistant
SELECT Birth_Date FROM People ORDER BY Height ASC
human
List the total scores of body builders in ascending order.
assistant
SELECT Total FROM body_builder ORDER BY Total ASC
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
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 birth date and birth place of the body builder with the highest total points?
assistant
SELECT T2.Birth_Date , T2.Birth_Place FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Total DESC LIMIT 1
human
What are the total scores of the body builders whose birthday contains the string 'January' ?
assistant
SELECT T1.total FROM body_builder AS T1 JOIN people AS T2 ON T1.people_id = T2.people_id WHERE T2.Birth_Date LIKE "%January%" ;