Create Table

CREATE TABLE spec (
   cods NUMBER(2), 
   nume VARCHAR2(10), 
   domeniu VARCHAR2(15)
 );
 INSERT INTO spec 
 VALUES 
   (
     11, 'MATEMATICA', 'STIINTE EXACTE'
   );
 INSERT INTO spec 
 VALUES 
   (21, 'GEOGRAFIE', 'UMANIST');
 INSERT INTO spec 
 VALUES 
   (24, 'ISTORIE', 'UMANIST');

CREATE TABLE stud (
   matr NUMBER(4), 
   nume VARCHAR2(10), 
   an NUMBER(1), 
   grupa VARCHAR2(6), 
   datan DATE, 
   loc VARCHAR2(10), 
   tutor NUMBER(4), 
   punctaj NUMBER(4), 
   cods NUMBER(2)
 );
 INSERT INTO stud 
 VALUES 
   (
     1456, 'GEORGE', 4, '1141A', '12-MAR-82', 
     'BUCURESTI', NULL, 2890, 11
   );
 INSERT INTO stud 
 VALUES 
   (
     1325, 'VASILE', 2, '1122A', '05-OCT-84', 
     'PITESTI', 1456, 390, 11
   );
 INSERT INTO stud 
 VALUES 
   (
     1645, 'MARIA', 3, '1131B', '17-JUN-83', 
     'PLOIESTI', NULL, 1400, 11
   );
 INSERT INTO stud 
 VALUES 
   (
     3145, 'ION', 1, '2112B', '24-JAN-85', 
     'PLOIESTI', 3251, 1670, 21
   );
 INSERT INTO stud 
 VALUES 
   (
     2146, 'STANCA', 4, '2141A', '15-MAY-82', 
     'BUCURESTI', NULL, 620, 21
   );
 INSERT INTO stud 
 VALUES 
   (
     3251, 'ALEX', 5, '2153B', '07-NOV-81', 
     'BRASOV', NULL, 1570, 21
   );
 INSERT INTO stud 
 VALUES 
   (
     2215, 'ELENA', 2, '2122A', '29-AUG-84', 
     'BUCURESTI', 2146, 890, 21
   );
 INSERT INTO stud 
 VALUES 
   (
     4311, 'ADRIAN', 3, '2431A', '31-JUL-83', 
     'BUCURESTI', NULL, 450, 24
   );
 INSERT INTO stud 
 VALUES 
   (
     3514, 'FLOREA', 5, '2452B', '03-FEB-81', 
     'BRASOV', NULL, 3230, 24
   );
 INSERT INTO stud 
 VALUES 
   (
     1925, 'OANA', 2, '2421A', '20-DEC-84', 
     'BUCURESTI', 4311, 760, 24
   );
 INSERT INTO stud 
 VALUES 
   (
     2101, 'MARIUS', 1, '2412B', '02-SEP-85', 
     'PITESTI', 3514, 310, 24
   );
 INSERT INTO stud 
 VALUES 
   (
     4705, 'VOICU', 2, '2421B', '19-APR-84', 
     'BRASOV', 4311, 1290, 24
   );

CREATE TABLE bursa (
   tip VARCHAR2(20), 
   pmin NUMBER(4), 
   pmax NUMBER(4), 
   suma NUMBER(4)
 );
 INSERT INTO bursa (pmin, pmax, tip, suma) 
 VALUES 
   (0, 399, 'FARA BURSA', NULL);
 INSERT INTO bursa (pmin, pmax, tip, suma) 
 VALUES 
   (400, 899, 'BURSA SOCIALA', 100);
 INSERT INTO bursa (pmin, pmax, tip, suma) 
 VALUES 
   (900, 1799, 'BURSA DE STUDIU', 150);
 INSERT INTO bursa (pmin, pmax, tip, suma) 
 VALUES 
   (1800, 2499, 'BURSA DE MERIT', 200);
 INSERT INTO bursa (pmin, pmax, tip, suma) 
 VALUES 
   (
     2500, 9999, 'BURSA DE EXCEPTIE', 300
   );