human
Schema:
member (Member_ID, Name, Nationality, Role)
performance (Performance_ID, Date, Host, Location, Attendance)
member_attendance (Member_ID, Performance_ID, Num_of_Pieces)
Please answer with SQL.
assistant
Sure, I understand.
human
Who are the attending members whose roles are 'Viola'?
assistant
SELECT Name FROM member WHERE Role = 'Viola';
human
How about Violin?
assistant
SELECT Name FROM member WHERE Role = "Violin" ;