count of signs

CREATE TABLE TBL_COUNT(ID INT)

 INSERT INTO TBL_COUNT VALUES(1),(-1),(-2),(1),(2),(-1),(1)

 SELECT * FROM TBL_COUNT

 SELECT SIGN(ID) AS ID,COUNT(ID) FROM TBL_COUNT GROUP BY SIGN(ID)