Andre Long
							 cisa 321 SQL
							quiz1


drop table l_100_best_songs_of_all_times;

create table l_100_best_songs_of_all_times
( Song_Title    varchar2(100),
  Publisher      varchar2(100),
  Artist             varchar2(200),
  Year              varchar2(4)      );


To put data onto new table

insert into l_100_best_songs_of_all_times   values ( 'Sittin'' On The Dock Of The Bay', 'Redding/Cropper', 'Otis Redding', '1967' );
insert into l_100_best_songs_of_all_times   values ( ' Heard It Through The Grapevine', 'Whitfield/Strong',  'Marvin Gaye', '1968' );
insert into l_100_best_songs_of_all_times   values ( 'Fall On Me', 'Mills/Buck/Berry/Stipe', 'R.E.M', '1986' );
insert into l_100_best_songs_of_all_times   values ( 'Everybody''s Talking', 'Neil', 'Harry Nilsson', '1969' );



To view new table

 select*
 from l_100_best_songs_of_all_times;