rem create table dates as
select to_char((to_date('01-jan-2008')+substr(acddate,2,30)),'YYYYMMDD') as accidentDate, 
       to_char((to_date('01-jan-2008')+substr(acddate,2,30)), 'MM') as accidentMonth,
       totalfatals, pedfatals,
       (totalfatals + pedfatals) as nummberofFatalities,
        substr(acddate,0,2) as temp
from acdl_crash_loc
where substr(acddate,0,2)=08
;