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
How many clubs are there?
assistant
SELECT count(*) FROM club
human
What is the location of the club named 'Tennis Club'?
assistant
SELECT clublocation FROM club WHERE clubname = 'Tennis Club'
human
List the clubs that have at least a member with advisor '1121'.
assistant
SELECT DISTINCT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid = t2.clubid JOIN student AS t3 ON t2.stuid = t3.stuid WHERE t3.advisor = 1121
human
How many clubs are located at 'HHH'?
assistant
SELECT count(*) FROM club WHERE clublocation = 'HHH'
human
What are the names of all clubs?
assistant
SELECT clubname FROM club
human
Which clubs are located at 'AKW'? Return the club names.
assistant
SELECT clubname FROM club WHERE clublocation = "AKW" ;