human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Dorm (dormid, dorm_name, student_capacity, gender)
Dorm_amenity (amenid, amenity_name)
Has_amenity (dormid, amenid)
Lives_in (stuid, dormid, room_number)
Please answer with SQL.
assistant
Sure, I understand.
human
Who are the students that are between 20 and 25 years of age? | Do you mean the last name or the first name of the students between 20 and 25 years of age? | What are the first names of the students who are between 20 and 25 years of age?
assistant
SELECT fname FROM student WHERE age BETWEEN 20 AND 25;
human
what are the student names who are in PHL city and are between 20 and 25 years of age | First name or last name? | first
assistant
SELECT fname FROM student WHERE city_code = "PHL" AND age BETWEEN 20 AND 25 ;