[16:04, 21/11/2019] Aakriti Gupta: CREATE GLOBAL TEMPORARY TABLE temptable (
  crime_date   varchar2(100),
  description  VARCHAR2(100)
)
[16:05, 21/11/2019] Aakriti Gupta: SELECT INSTR(SUBSTR(t.CRIME_DATE, INSTR(t.CRIME_DATE, ' ')+1),' ') AS col_two FROM NARORA.CRIME t
SELECT CRIME_DATE FROM NARORA.CRIME


SELECT * FROM(SELECT COUNT(CRIME_ID),CRIME_DATE FROM NARORA.CRIME C FULL OUTER JOIN NARORA.LOCATION L ON C.LOCATION_ID=L.LOCATION_ID WHERE BLOCKS='024XX E 79TH ST'
  GROUP BY CRIME_DATE)T WHERE (select extract(year from sysdate)-(SELECT SUBSTR(SUBSTR(CRIME_DATE,7,7),0,4) FROM NARORA.CRIME)<5)