When did the violin players perform?
select t3.date from member_attendance as t1 join member as t2 on t1.member_id = t2.member_id join performance as t3 on t1.performance_id = t3.performance_id where t2.role = "Violin"
Yes, what is the name of the violin player who attended the most number of performances?
select t1.name from member as t1 join member_attendance as t2 on t1.member_id = t2.member_id group by t2.member_id order by count ( * ) desc limit 1
What about the violin player who attended the least performances?
select t1.name from member as t1 join member_attendance as t2 on t1.member_id = t2.member_id group by t2.member_id order by count ( * ) asc limit 1