CASE 
WHEN `GameId` IN ('27007','28001','27008','27009') THEN 
    CASE 
        WHEN `action` = '1' THEN NetWin
        WHEN `action` = '2' THEN NetWin
        ELSE 0 
    END
ELSE 
CASE 
 WHEN `action` = '2' THEN NetWin 
 WHEN `action` = '3' THEN amount 
ELSE 0 
END
END