DROP TABLE QUOTATIONS;                                                          
                                                                                
CREATE TABLE QUOTATIONS                                                         
     (SUPPNO    SMALLINT,                                                       
      PARTNO    SMALLINT,                                                       
      PRICE     DECIMAL(4,2),                                                   
      DELIVERY_TIME   SMALLINT,                                                 
      QONORDER  SMALLINT);                                                      
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (51, 221, .30, 10, 50);                                                    
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (51,231,.10,10,0);                                                         
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (53,222,.25,15,0);                                                         
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (53,232,.10,15,200);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (53,241,.08,15,0);                                                         
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (54,209,18.00,21,0);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (54,221,.10,30,150);                                                        
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (54,231,.04,30,200);                                                        
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (54,241,.02,30,200);                                                        
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (57,285,21.00,14,0);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (57,295,8.50,21,24);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (61,221,.20,21,0);                                                         
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
     (61,222,.20,21,200);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (61,241,.05,21,0);                                                          
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (64,207,29.00,14,20);                                                       
                                                                                
INSERT INTO QUOTATIONS VALUES                                                   
    (64,209,19.50,7,7);                                                         
