human
Schema:
candidate (Candidate_ID, People_ID, Poll_Source, Date, Support_rate, Consider_rate, Oppose_rate, Unsure_rate)
people (People_ID, Sex, Name, Date_of_Birth, Height, Weight)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the current height of Hubert Henno
assistant
SELECT height FROM people WHERE Name = 'Hubert Henno';
human
How many male sex are there
assistant
SELECT COUNT( * ) FROM people WHERE Sex = 'M';
human
which of the male has he highest weight | Would you like to know the name of the person who has the highest weight among sex M? | yes of course
assistant
SELECT name FROM people WHERE Sex = "M" ORDER BY Height DESC LIMIT 1 ;