drop  table project;

create table project (project_name char(15), start_date char(10), end_date 		
                      char(10), authorized char(26));
insert into  project (project_name,start_date, end_date, authorized)
             values ('BLUE MACHINE', '1988-08-15', 
                '1988-12-16','1988-06-30-16.00.29.000000');

insert into  project (project_name,start_date, end_date, authorized)
             values ('GREEN MACHINE', '1990-04-27',
                '1990-12-18','1990-01-26-10.00.03.000299');   

insert into  project (project_name,start_date, end_date, authorized)
             values ('ORANGE MACHINE', '1989-07-10',
                '1990-06-04','1988-10-11-09.45.00.000000');   

insert into  project (project_name,start_date, end_date,authorized) 
               values ('RED MACHINE', '1988-02-01',
                '1990-01-12','1987-12-14-08.30.01.000000');   

insert into  project (project_name,start_date, end_date,authorized) 
             values ('WHITE MACHINE', '1988-09-19',
                '1988-11-11','1987-11-03-18.34.02.000999');   	    	      
                                                                 
