Getting Count For Duplicate Values And Distinct Value

Getting Count For Duplicate Values And Distinct Value?

STEP 1:-
create table t1(t1 VARCHAR2(5),C2 VARCHAR2(5),C3 VARCHAR2(5));
create table t2(t1 VARCHAR2(5),C2 VARCHAR2(5),C3 VARCHAR2(5),C4 VARCHAR2(10));

INSERT INTO t1 values('a','b','c'); 
INSERT INTO t1 values('a','b','c'); 
INSERT INTO t1 values('x','y','z'); 
INSERT INTO t1 values('x','y','z'); 
INSERT INTO t1 values('a','s','d'); 
INSERT INTO t1 values('z','x','c'); 
INSERT INTO t1 values('v','b','n'); 
INSERT INTO t1 values('v','b','n'); 
INSERT INTO t1 values('q','w','e'); 
INSERT INTO t1 values('x','c','v'); 
COMMIT;


STEP:2