query help

I need to build a Following query , now for the most Street values are 'UNKNOWN'
and for most State values are 'XX'.




same address different company name
following is the table (create table inc_company

ID NOT NULL VARCHAR2(9),
NAME NOT NULL VARCHAR2(30),
STREET VARCHAR2(30),
CITY VRCHAR2(25),
STATE VARCHAR2(2),
ZIPCODE VARCHAR2(10));