drop table students;
create table students
     (SID varchar2(6) constraint students_SID_pk primary key,
      last varchar2(12),
      first varchar2(12),
      middle char(1),
      major varchar2(4),
      sex varchar2(1),
      phone varchar2(8),
      birthday date,
      gpa number(5,3),
      rank char(2));
insert into students values ('123456','Smith','Robert','M','ACTG','M','555-1234','14-MAR-1980',1.8,'SR');
insert into students values ('123457','Jones','Frank','A','MGNT','M','555-9874','24-FEB-1982',3.2,'FR');
insert into students values ('123458','Davis','Julia','B','INSY','F','555-3975','12-MAR-1980',2.2,'SO');
insert into students values ('123459','Adams','Kelly','D','ACTG','F','555-8798','04-JUN-1985',3.5,'JR');
insert into students values ('223451','Smith','Dave','F','MGNT','M','555-9874','01-SEP-1982',3.8,'FR');
insert into students values ('223452','Franks','Marcus','B','INSY','M','555-1234','30-MAR-1980',4.0,'JR');
insert into students values ('223453','Love','Paul','D','ACTG','M','555-7834','22-APR-1980',1.9,'SO');
insert into students values ('223454','Paulson','Ashley','X','ACTG','F','555-1254','05-FEB-1972',2.4,'JR');
insert into students values ('223455','Crabtree','Doreen','G','MGNT','F','555-8798','25-DEC-1980',2.8,'SO');
insert into students values ('223456','Bogart','Karen','C','INSY','F','555-1432','24-DEC-1981',3.0,'JR');
insert into students values ('223457','Woodson','Fred','K','ACTG','M','555-1334','15-MAY-1982',3.9,'FR');
insert into students values ('223458','Hall','Bobby','J','MGNT','M','555-1444','12-AUG-1981',3.2,'JR');
insert into students values ('223459','BirgSong','Carl','Y','INSY','M','555-1114','11-JAN-1980',2.5,'SO');
insert into students values ('323451','Clinton','Carl','F','ACTG','M','555-1123','09-NOV-1983',2.0,'FR');
insert into students values ('323452','Davis','Nancy','P','INSY','F','555-1888','29-OCT-1982',2.2,'JR');
insert into students values ('323453','Holt','Kathy','M','INSY','F','555-1988','30-JUL-1964',3.2,'JR');
insert into students values ('323454','Holton','Jacob','N','ACTG','M','555-1111','12-JAN-1981',3.5,'JR');
insert into students values ('323455','Peters','Justin','N','MGNT','M','555-9890','04-MAR-1980',3.4,'SO');
insert into students values ('323456','Haught','Kara','R','INSY','F','555-6756','05-FEB-1982',3.1,'JR');
insert into students values ('323457','Vaught','Jason','A','ACTG','M','555-3999','06-MAR-1983',2.2,'FR');
insert into students values ('323458','Osborne','Mark','B','INSY','M','555-5432','11-DEC-1977',2.4,'FR');
insert into students values ('323459','Balter','Shannon','C','MGNT','F','555-7348','11-NOV-1983',2.8,'JR');
insert into students values ('423451','Smith','Cre','K','MGNT','F','555-9800','11-OCT-1981',4.0,'JR');
insert into students values ('423452','Redmond','Jessica','D','INSY','F','555-4007','23-DEC-1982',3.2,'FR');
insert into students values ('423453','Sides','Susan','F','ACTG','F','555-4444','24-JUL-1980',2.7,'SR');
insert into students values ('423454','Fisher','Joe','G','MGNT','M','555-1234','29-JUN-1980',3.6,'SR');
insert into students values ('423455','Bath','Nathan','B','INSY','M','555-3987','20-JAN-1982',3.3,'FR');
insert into students values ('423456','Loney','Larry','B','ACTG','M','555-7634','10-APR-1981',2.3,'SO');
commit;