human
Schema:
member (Member_ID, Card_Number, Name, Hometown, Level)
branch (Branch_ID, Name, Open_year, Address_road, City, membership_amount)
membership_register_branch (Member_ID, Branch_ID, Register_Year)
purchase (Member_ID, Branch_ID, Year, Total_pounds)
Please answer with SQL.
assistant
Sure, I understand.
human
show the minimum amount of memberships for all branches opened in 2011 or located at city location
assistant
SELECT MIN( membership_amount ) FROM branch WHERE open_year = 2011 OR city = 'London';
human
show the maximum amount of memberships for all branches opened in 2011 or located at city location
assistant
SELECT MAX( membership_amount ) FROM branch WHERE open_year = 2011 OR city = "London" ;