這個也可以用 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 :(