human
Schema:
Allergy_Type (Allergy, AllergyType)
Has_Allergy (StuID, Allergy)
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Please answer with SQL.
assistant
Sure, I understand.
human
how many female students presented on table
assistant
SELECT COUNT( * ) FROM Student WHERE Sex = 'F';
human
what is the age of smith | Do you mean the age of the student whose last name is Smith? | exactly
assistant
SELECT Age FROM Student WHERE LName = 'Smith';
human
exactly | I mean which one do you want to know, first name or last name or both? | i want first name
assistant
SELECT FName FROM Student ORDER BY Advisor DESC LIMIT 1 ;