CREATE TABLE T1
      (
      T1_ID NUMBER PRIMARY KEY,
      NAME VARCHAR2(20) NOT NULL
      )

      CREATE TABLE T2
      (
      T2_ID NUMBER PRIMARY KEY,
      NAME VARCHAR2(50) NOT NULL,
      T1_ID NUMBER NOT NULL,
      CONSTRAINT T1_FK FOREIGN KEY (T1_ID)
      REFERENCES T1(T1_ID)
      )

      CREATE TABLE T3
      (
      T3_ID NUMBER PRIMARY KEY,
      PRICE FLOAT NOT NULL,
      INS_DATE date default sysdate,      
      T2_ID NUMBER NOT NULL,              
      CONSTRAINT T2_FK FOREIGN KEY (T2_ID)
      REFERENCES T2(T2_ID)
      )  
////////////////////////////
INSERT ALL
       INTO T1 (T1_ID,NAME) VALUES (1,'BEM')
       INTO T1 (T1_ID,NAME) VALUES (2,'KIN')
       INTO T1 (T1_ID,NAME) VALUES (3,'STURTS')       

       INTO T2 (T2_ID, NAME,T1_ID) VALUES(1,'VLES',2)
       INTO T2 (T2_ID, NAME,T1_ID) VALUES(2,'WAR',2)
       INTO T2 (T2_ID, NAME,T1_ID) VALUES(3,'RECD',1)
       INTO T2 (T2_ID, NAME,T1_ID) VALUES(4,'FARE',3)
       
        INTO T3 (T3_ID, PRICE,T2_ID) VALUES(1,22,1)
        INTO T3 (T3_ID, PRICE,T2_ID) VALUES(2,3,2)
        INTO T3 (T3_ID, PRICE,T2_ID) VALUES(3,1000,4)
		INTO T3 (T3_ID, PRICE,T2_ID) VALUES(4,86,3)
      SELECT * FROM DUAL;

SELECT
      Nvl(T3_ID,'')AS id,Sum(price) AS price
FROM T3
      GROUP BY rollup(T3_ID);

SELECT 
        T1.NAME,
        T2.NAME,
        T3.PRICE,
        T3.INS_DATE
     FROM T1,T2,T3
     WHERE
        T1.T1_ID = T2.T1_ID
     AND
        T3.T2_ID = T2.T2_ID;

SELECT 
        T1.NAME,
        T2.NAME,
        sum(T3.PRICE) price,
        T3.INS_DATE
     FROM T1,T2,T3
     WHERE
        T1.T1_ID = T2.T1_ID
     AND
        T3.T2_ID = T2.T2_ID
group by T1.NAME,T2.NAME,T3.INS_DATE;