Could you please show the membership level with the greatest number of members?
select level from member group by level order by count ( * ) desc limit 1
What are the member ids of the people who have that membership level?
select member_id from member where level in ( select level from member group by level order by count ( * ) desc limit 1 )
What are their names, please?
select name from member where level in ( select level from member group by level order by count ( * ) desc limit 1 )
What about the membership level with the least number of members?
select level from member group by level order by count ( * ) asc limit 1
What are the member ids of the people who have that membership level?
select member_id from member where level in ( select level from member group by level order by count ( * ) asc limit 1 )
What is their name, please?
select name from member where level in ( select level from member group by level order by count ( * ) asc limit 1 )