SELECT
balance,
SUM(CASE WHEN sipID = 0 THEN 1 ELSE 0 END),
SUM(CASE WHEN sipID > 0 THEN 1 ELSE 0 END)
FROM
tablo
GROUP BY
balance