query analysis in AWR history

consumtion_analysis.sql

SELECT 
DSQL.SNAP_ID,  
DSQL.INSTANCE_NUMBER INST, --DSQL.PLAN_HASH_VALUE PLANH, 
 to_char((select END_INTERVAL_TIME from DBA_HIST_SNAPSHOT where SNAP_ID=DSQL.SNAP_ID and rownum <2),'DD/MON HH24:MI') "DATE",
  ROUND((ELAPSED_TIME_DELTA/1000000)/DECODE(EXECUTIONS_DELTA,0,1,EXECUTIONS_DELTA),5) AVG_EXEC_TIME, DSQL.EXECUTIONS_DELTA EXD,
  (DSQL.CPU_TIME_DELTA / (1000000)) CPU_TIME, DSQL.SQL_ID , BUFFER_GETS_DELTA
    FROM DBA_HIST_SQLSTAT DSQL
   WHERE DSQL.SQL_ID IN ('')
     AND DSQL.SNAP_ID BETWEEN  AND 
ORDER BY 2,7,3



SELECT 
--DSQL.SNAP_ID,  
--DSQL.EXECUTIONS_DELTA EXD,round(decode(DSQL.ELAPSED_TIME_DELTA * DSQL.EXECUTIONS_DELTA, 0, DSQL.EXECUTIONS_DELTA, DSQL.ELAPSED_TIME_DELTA/1000000/DSQL.EXECUTIONS_DELTA),5) as Average_time,
DSQL.INSTANCE_NUMBER INST, --DSQL.PLAN_HASH_VALUE PLANH, 
 (select END_INTERVAL_TIME from DBA_HIST_SNAPSHOT where SNAP_ID=DSQL.SNAP_ID and rownum <2) "DATE",
  ROUND((ELAPSED_TIME_DELTA/1000000)/DECODE(EXECUTIONS_DELTA,0,1,EXECUTIONS_DELTA),5) AVG_EXEC_TIME, DSQL.EXECUTIONS_DELTA EXD,
  (DSQL.CPU_TIME_DELTA / (1000000)) CPU_TIME, DSQL.SQL_ID , BUFFER_GETS_DELTA
    FROM DBA_HIST_SQLSTAT DSQL
   WHERE DSQL.SQL_ID in ('')
     AND DSQL.SNAP_ID
         IN (SELECT SNAP_ID FROM DBA_HIST_SNAPSHOT WHERE BEGIN_INTERVAL_TIME BETWEEN TO_DATE('22102015 17:30:00','ddmmyyyy hh24:mi:ss') 
                            AND TO_DATE('22102015 19:30:00','ddmmyyyy hh24:mi:ss'))
ORDER BY 1, 2 ;


SELECT 
DSQL.INSTANCE_NUMBER INST, 
 (select END_INTERVAL_TIME from DBA_HIST_SNAPSHOT where SNAP_ID=DSQL.SNAP_ID and rownum <2) "DATE",
  ROUND((ELAPSED_TIME_DELTA/1000000)/DECODE(EXECUTIONS_DELTA,0,1,EXECUTIONS_DELTA),5) AVG_EXEC_TIME, DSQL.EXECUTIONS_DELTA EXD,
  (DSQL.CPU_TIME_DELTA / (1000000)) CPU_TIME, DSQL.SQL_ID , BUFFER_GETS_DELTA
    FROM DBA_HIST_SQLSTAT DSQL
   WHERE DSQL.SQL_ID IN ('')
     AND DSQL.SNAP_ID 
        between  and   
ORDER BY 1, 2 ;