Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (FileID int, FileInfo varchar2(1));
INSERT ALL 
    INTO tablename (FileID, FileInfo)
         VALUES (1, 'X')
    INTO tablename (FileID, FileInfo)
         VALUES (1, 'Y')
    INTO tablename (FileID, FileInfo)
         VALUES (2, 'Y')
    INTO tablename (FileID, FileInfo)
         VALUES (2, 'Z')
    INTO tablename (FileID, FileInfo)
         VALUES (2, 'A')
SELECT * FROM dual;
5 rows affected

SELECT FileID,
       COUNT(CASE WHEN counter = 1 THEN 1 END) count_unique,
       COUNT(CASE WHEN counter > 1 THEN 1 END) count_non_unique
FROM (
  SELECT t.*, COUNT(*) OVER (PARTITION BY t.FileInfo) counter
  FROM tablename t
) t
GROUP BY FileID;  


FILEID
COUNT_UNIQUE
COUNT_NON_UNIQUE


1
1
1

2
2
1