並前往https://www.bbsmax.com/topic/sql-group-by%E5%9C%A8case-when%E5%89%8D%E6%89%A7%E8%A1%8C%E9%A1%BA%E5%BA%8F/