SELECT NAM,
SUM(CASE WHEN JIEGUO='WIN' THEN 1 ELS 0 END) AS WIN_NUM,
SUM(CASE WHEN JIEGUO='WIN' THEN 0 ELS 1 END) AS LOST_NUM
FROM TABLE_1
GROUP BY NAM
SUM(CASE WHEN JIEGUO='WIN' THEN 1 ELS 0 END) AS WIN_NUM,
SUM(CASE WHEN JIEGUO='WIN' THEN 0 ELS 1 END) AS LOST_NUM
FROM TABLE_1
GROUP BY NAM
NAM,
MAX(CASE WHEN JIEGUO='WIN' THEN COUNT(JIEGUO) ELSE 0 END) AS WIN_NUM ,
MAX(CASE WHEN JIEGUO='LOST ' THEN COUNT(LOST ) ELSE 0 END) AS LOST_NUM
FROM TB
GROUP BY NAM