这个也可以用 pivot 解, 不过窍门一样, 要先把帐号改掉
select * from (
select FuncName, IIF(UserName = 'guest', 'guest', 'member') typ
from tb1
) S
pivot (
count(typ) for
typ in (guest, member)
) pvt
※ 引述《cutekid (可爱小孩子)》之铭言：
: https://imgur.com/a/6TEnMEw
:

wait, MySQL doesn't have Pivot. Sorry :(