human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Club (ClubID, ClubName, ClubDesc, ClubLocation)
Member_of_club (StuID, ClubID, Position)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the location of Bootup Baltimore
assistant
SELECT ClubLocation FROM Club WHERE ClubName = 'Bootup Baltimore';
human
how many female students are presented on the table
assistant
SELECT COUNT( StuID ) FROM Student WHERE Sex = 'F';
human
what is the major of Tracy
assistant
SELECT Major FROM Student WHERE Fname = "Tracy" ;