northwind.script

一个java开源报表工具

CREATE TABLE CATEGORIES(CATEGORYID INTEGER,CATEGORYNAME VARCHAR,DESCRIPTION LONGVARCHAR)
CREATE TABLE CUSTOMERS(CUSTOMERID VARCHAR,COMPANYNAME VARCHAR,CONTACTNAME VARCHAR,CONTACTTITLE VARCHAR,ADDRESS VARCHAR,CITY VARCHAR,REGION VARCHAR,POSTALCODE VARCHAR,COUNTRY VARCHAR,PHONE VARCHAR,FAX VARCHAR)
CREATE TABLE EMPLOYEES(EMPLOYEEID INTEGER,LASTNAME VARCHAR,FIRSTNAME VARCHAR,TITLE VARCHAR,TITLEOFCOURTESY VARCHAR,BIRTHDATE TIMESTAMP,HIREDATE TIMESTAMP,ADDRESS VARCHAR,CITY VARCHAR,REGION VARCHAR,POSTALCODE VARCHAR,COUNTRY VARCHAR,HOMEPHONE VARCHAR,EXTENSION VARCHAR,NOTES LONGVARCHAR,REPORTSTO INTEGER)
CREATE TABLE ORDERDETAILS(ORDERID INTEGER,PRODUCTID INTEGER,UNITPRICE NUMERIC,QUANTITY SMALLINT,DISCOUNT REAL)
CREATE TABLE ORDERS(ORDERID INTEGER,CUSTOMERID VARCHAR,EMPLOYEEID INTEGER,ORDERDATE TIMESTAMP,REQUIREDDATE TIMESTAMP,SHIPPEDDATE TIMESTAMP,SHIPVIA INTEGER,FREIGHT NUMERIC,SHIPNAME VARCHAR,SHIPADDRESS VARCHAR,SHIPCITY VARCHAR,SHIPREGION VARCHAR,SHIPPOSTALCODE VARCHAR,SHIPCOUNTRY VARCHAR)
CREATE TABLE PRODUCTS(PRODUCTID INTEGER,PRODUCTNAME VARCHAR,SUPPLIERID INTEGER,CATEGORYID INTEGER,QUANTITYPERUNIT VARCHAR,UNITPRICE NUMERIC,UNITSINSTOCK SMALLINT,UNITSONORDER SMALLINT,REORDERLEVEL SMALLINT,DISCONTINUED BOOLEAN)
CREATE TABLE SHIPPERS(SHIPPERID INTEGER,COMPANYNAME VARCHAR,PHONE VARCHAR)
CREATE TABLE SUPPLIERS(SUPPLIERID INTEGER,COMPANYNAME VARCHAR,CONTACTNAME VARCHAR,CONTACTTITLE VARCHAR,ADDRESS VARCHAR,CITY VARCHAR,REGION VARCHAR,POSTALCODE VARCHAR,COUNTRY VARCHAR,PHONE VARCHAR,FAX VARCHAR)
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO CATEGORIES VALUES(2,'Condiments','Sweet and savory sauces, relishes, spreads, and seasonings')
INSERT INTO CATEGORIES VALUES(3,'Confections','Desserts, candies, sweetbreads')
INSERT INTO CATEGORIES VALUES(4,'Dairy Products','Cheeses')
INSERT INTO CATEGORIES VALUES(5,'Grains/Cereals','Breads, crackers, pasta, and cereal')
INSERT INTO CATEGORIES VALUES(6,'Meat/Poultry','Prepared meats')
INSERT INTO CATEGORIES VALUES(7,'Produce','Dried fruit and bean curd')
INSERT INTO CATEGORIES VALUES(8,'Seafood','Seaweed and fish')
INSERT INTO CUSTOMERS VALUES('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin','xxx yyy','12209','Germany','030-0074321','030-0076545')
INSERT INTO CUSTOMERS VALUES('ANATR','Ana Trujillo Emparedados y helados','Ana Trujillo ddddd','Owner','Avda. de la Constituci\u00f3n 2222','M\u00e9xico D.F.',NULL,'05021','Mexico','(5) 555-4729','(5) 555-3745')
INSERT INTO CUSTOMERS VALUES('ANTON','Antonio Moreno Taquer\u00eda','Antonio Moreno cccccc','Owner','Mataderos  2312','M\u00e9xico D.F.',NULL,'05023','Mexico','(5) 555-3932',NULL)
INSERT INTO CUSTOMERS VALUES('AROUT','Around the Horn','Thomas Hardy','Sales Representative','120 Hanover Sq.','London',NULL,'WA1 1DP','UK','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('BERGS','Berglunds snabbk\u00f6p','Christina Berglund','Order Administrator','Berguvsv\u00e4gen  8','Lule\u00e5',NULL,'S-958 22','Sweden','0921-12 34 65','0921-12 34 67')
INSERT INTO CUSTOMERS VALUES('BLAUS','Blauer See Delikatessen','Hanna Moos','Sales Representative','Forsterstr. 57','Mannheim',NULL,'68306','Germany','0621-08460','0621-08924')
INSERT INTO CUSTOMERS VALUES('BLONP','Blondel p\u00e8re et fils','Fr\u00e9d\u00e9rique Citeaux','Marketing Manager','24, place Kl\u00e9ber','Strasbourg',NULL,'67000','France','88.60.15.31','88.60.15.32')
INSERT INTO CUSTOMERS VALUES('BOLID','B\u00f3lido Comidas preparadas','Mart\u00edn Sommer','Owner','C/ Araquil, 67','Madrid',NULL,'28023','Spain','(91) 555 22 82','(91) 555 91 99')
INSERT INTO CUSTOMERS VALUES('BONAP','Bon app''','Laurence Lebihan','Owner','12, rue des Bouchers','Marseille',NULL,'13008','France','91.24.45.40','91.24.45.41')
INSERT INTO CUSTOMERS VALUES('BOTTM','Bottom-Dollar Markets','Elizabeth Lincoln','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('BSBEV','B''s Beverages','Victoria Ashworth','Sales Representative','Fauntleroy Circus','London',NULL,'EC2 5NT','UK','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('CACTU','Cactus Comidas para llevar','Patricio Simpson','Sales Agent','Cerrito 333','Buenos Aires',NULL,'1010','Argentina','(1) 135-5555','(1) 135-4892')
INSERT INTO CUSTOMERS VALUES('CENTC','Centro comercial Moctezuma','Francisco Chang','Marketing Manager','Sierras de Granada 9993','M\u00e9xico D.F.',NULL,'05022','Mexico','(5) 555-3392','(5) 555-7293')
INSERT INTO CUSTOMERS VALUES('CHOPS','Chop-suey Chinese','Yang Wang','Owner','Hauptstr. 29','Bern',NULL,'3012','Switzerland','0452-076545',NULL)
INSERT INTO CUSTOMERS VALUES('COMMI','Com\u00e9rcio Mineiro','Pedro Afonso','Sales Associate','Av. dos Lus\u00edadas, 23','S\u00e3o Paulo','SP','05432-043','Brazil','(11) 555-7647',NULL)
INSERT INTO CUSTOMERS VALUES('CONSH','Consolidated Holdings','Elizabeth Brown','Sales Representative','Berkeley Gardens\u000d\u000a12  Brewery ','London',NULL,'WX1 6LT','UK','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('DRACD','Drachenblut Delikatessen','Sven Ottlieb','Order Administrator','Walserweg 21','Aachen',NULL,'52066','Germany','0241-039123','0241-059428')
INSERT INTO CUSTOMERS VALUES('DUMON','Du monde entier','Janine Labrun','Owner','67, rue des Cinquante Otages','Nantes',NULL,'44000','France','40.67.88.88','40.67.89.89')
INSERT INTO CUSTOMERS VALUES('EASTC','Eastern Connection','Ann Devon','Sales Agent','35 King George','London',NULL,'WX3 6FW','UK','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('ERNSH','Ernst Handel','Roland Mendel','Sales Manager','Kirchgasse 6','Graz',NULL,'8010','Austria','7675-3425','7675-3426')
INSERT INTO CUSTOMERS VALUES('FAMIA','Familia Arquibaldo','Aria Cruz','Marketing Assistant','Rua Or\u00f3s, 92','S\u00e3o Paulo','SP','05442-030','Brazil','(11) 555-9857',NULL)
INSERT INTO CUSTOMERS VALUES('FISSA','FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','Accounting Manager','C/ Moralzarzal, 86','Madrid',NULL,'28034','Spain','(91) 555 94 44','(91) 555 55 93')
INSERT INTO CUSTOMERS VALUES('FOLIG','Folies gourmandes','Martine Ranc\u00e9','Assistant Sales Agent','184, chauss\u00e9e de Tournai','Lille',NULL,'59000','France','20.16.10.16','20.16.10.17')
INSERT INTO CUSTOMERS VALUES('FOLKO','Folk och f\u00e4 HB','Maria Larsson','Owner','\u00c5kergatan 24','Br\u00e4cke',NULL,'S-844 67','Sweden','0695-34 67 21',NULL)
INSERT INTO CUSTOMERS VALUES('FRANK','Frankenversand','Peter Franken','Marketing Manager','Berliner Platz 43','M\u00fcnchen',NULL,'80805','Germany','089-0877310','089-0877451')
INSERT INTO CUSTOMERS VALUES('FRANR','France restauration','Carine Schmitt','Marketing Manager','54, rue Royale','Nantes',NULL,'44000','France','40.32.21.21','40.32.21.20')
INSERT INTO CUSTOMERS VALUES('FRANS','Franchi S.p.A.','Paolo Accorti','Sales Representative','Via Monte Bianco 34','Torino',NULL,'10100','Italy','011-4988260','011-4988261')
INSERT INTO CUSTOMERS VALUES('FURIB','Furia Bacalhau e Frutos do Mar','Lino Rodriguez ','Sales Manager','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal','(1) 354-2534','(1) 354-2535')
INSERT INTO CUSTOMERS VALUES('GALED','Galer\u00eda del gastr\u00f3nomo','Eduardo Saavedra','Marketing Manager','Rambla de Catalu\u00f1a, 23','Barcelona',NULL,'08022','Spain','(93) 203 4560','(93) 203 4561')
INSERT INTO CUSTOMERS VALUES('GODOS','Godos Cocina T\u00edpica','Jos\u00e9 Pedro Freyre','Sales Manager','C/ Romero, 33','Sevilla',NULL,'41101','Spain','(95) 555 82 82',NULL)
INSERT INTO CUSTOMERS VALUES('GOURL','Gourmet Lanchonetes','Andr\u00e9 Fonseca','Sales Associate','Av. Brasil, 442','Campinas','SP','04876-786','Brazil','(11) 555-9482',NULL)
INSERT INTO CUSTOMERS VALUES('GREAL','Great Lakes Food Market','Howard Snyder-Fast','Marketing Manager','2732 Baker Blvd.','Eugene','OR','97403','USA','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('GROSR','GROSELLA-Restaurante','Manuel Pereira','Owner','5\u00aa Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela','(2) 283-2951','(2) 283-3397')
INSERT INTO CUSTOMERS VALUES('HANAR','Hanari Carnes','Mario Pontes','Accounting Manager','Rua do Pa\u00e7o, 67','Rio de Janeiro','RJ','05454-876','Brazil','(21) 555-0091','(21) 555-8765')
INSERT INTO CUSTOMERS VALUES('HILAA','HILARI\u00d3N-Abastos','Carlos Hern\u00e1ndez','Sales Representative','Carrera 22 con Ave. Carlos Soublette #8-35','San Crist\u00f3bal','T\u00e1chira','5022','Venezuela','(5) 555-1340','(5) 555-1948')
INSERT INTO CUSTOMERS VALUES('HUNGC','Hungry Coyote Import Store','Yoshi Latimer','Sales Representative','City Center Plaza\u000d\u000a516 Main St.','Elgin','OR','97827','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('HUNGO','Hungry Owl All-Night Grocers','Patricia McKenna','Sales Associate','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland','2967 542','2967 3333')
INSERT INTO CUSTOMERS VALUES('ISLAT','Island Trading','Helen Bennett','Marketing Manager','Garden House\u000d\u000aCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('KOENE','K\u00f6niglich Essen','Philip Cramer','Sales Associate','Maubelstr. 90','Brandenburg',NULL,'14776','Germany','0555-09876',NULL)
INSERT INTO CUSTOMERS VALUES('LACOR','La corne d''abondance','Daniel Tonini','Sales Representative','67, avenue de l''Europe','Versailles',NULL,'78000','France','30.59.84.10','30.59.85.11')
INSERT INTO CUSTOMERS VALUES('LAMAI','La maison d''Asie','Annette Roulet','Sales Manager','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France','61.77.61.10','61.77.61.11')
INSERT INTO CUSTOMERS VALUES('LAUGB','Laughing Bacchus Wine Cellars','Yoshi Tannamuri','Marketing Assistant','1900 Oak St.','Vancouver','BC','V3F 2K1','Canada','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('LAZYK','Lazy K Kountry Store','John Steel','Marketing Manager','12 Orchestra Terrace','Walla Walla','WA','99362','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('LEHMS','Lehmanns Marktstand','Renate Messner','Sales Representative','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany','069-0245984','069-0245874')
INSERT INTO CUSTOMERS VALUES('LETSS','Let''s Stop N Shop','Jaime Yorres','Owner','87 Polk St.\u000d\u000aSuite 5','San Francisco','CA','94117','USA','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('LILAS','LILA-Supermercado','Carlos Gonz\u00e1lez','Accounting Manager','Carrera 52 con Ave. Bol\u00edvar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela','(9) 331-6954','(9) 331-7256')
INSERT INTO CUSTOMERS VALUES('LINOD','LINO-Delicateses','Felipe Izquierdo','Owner','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela','(8) 34-56-12','(8) 34-93-93')
INSERT INTO CUSTOMERS VALUES('LONEP','Lonesome Pine Restaurant','Fran Wilson','Sales Manager','89 Chiaroscuro Rd.','Portland','OR','97219','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('MAGAA','Magazzini Alimentari Riuniti','Giovanni Rovelli','Marketing Manager','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy','035-640230','035-640231')
INSERT INTO CUSTOMERS VALUES('MAISD','Maison Dewey','Catherine Dewey','Sales Agent','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium','(02) 201 24 67','(02) 201 24 68')
INSERT INTO CUSTOMERS VALUES('MEREP','M\u00e8re Paillarde','Jean Fresni\u00e8re','Marketing Assistant','43 rue St. Laurent','Montr\u00e9al','Qu\u00e9bec','H1J 1C3','Canada','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('MORGK','Morgenstern Gesundkost','Alexander Feuer','Marketing Assistant','Heerstr. 22','Leipzig',NULL,'04179','Germany','0342-023176',NULL)
INSERT INTO CUSTOMERS VALUES('NORTS','North/South','Simon Crowther','Sales Associate','South House\u000d\u000a300 Queensbridge','London',NULL,'SW7 1RZ','UK','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('OCEAN','Oc\u00e9ano Atl\u00e1ntico Ltda.','Yvonne Moncada','Sales Agent','Ing. Gustavo Moncada 8585\u000d\u000aPiso 20-A','Buenos Aires',NULL,'1010','Argentina','(1) 135-5333','(1) 135-5535')
INSERT INTO CUSTOMERS VALUES('OLDWO','Old World Delicatessen','Rene Phillips','Sales Representative','2743 Bering St.','Anchorage','AK','99508','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('OTTIK','Ottilies K\u00e4seladen','Henriette Pfalzheim','Owner','Mehrheimerstr. 369','K\u00f6ln',NULL,'50739','Germany','0221-0644327','0221-0765721')
INSERT INTO CUSTOMERS VALUES('PARIS','Paris sp\u00e9cialit\u00e9s','Marie Bertrand','Owner','265, boulevard Charonne','Paris',NULL,'75012','France','(1) 42.34.22.66','(1) 42.34.22.77')
INSERT INTO CUSTOMERS VALUES('PERIC','Pericles Comidas cl\u00e1sicas','Guillermo Fern\u00e1ndez','Sales Representative','Calle Dr. Jorge Cash 321','M\u00e9xico D.F.',NULL,'05033','Mexico','(5) 552-3745','(5) 545-3745')
INSERT INTO CUSTOMERS VALUES('PICCO','Piccolo und mehr','Georg Pipps','Sales Manager','Geislweg 14','Salzburg',NULL,'5020','Austria','6562-9722','6562-9723')
INSERT INTO CUSTOMERS VALUES('PRINI','Princesa Isabel Vinhos','Isabel de Castro','Sales Representative','Estrada da sa\u00fade n. 58','Lisboa',NULL,'1756','Portugal','(1) 356-5634',NULL)
INSERT INTO CUSTOMERS VALUES('QUEDE','Que Del\u00edcia','Bernardo Batista','Accounting Manager','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil','(21) 555-4252','(21) 555-4545')
INSERT INTO CUSTOMERS VALUES('QUEEN','Queen Cozinha','L\u00facia Carvalho','Marketing Assistant','Alameda dos Can\u00e0rios, 891','S\u00e3o Paulo','SP','05487-020','Brazil','(11) 555-1189',NULL)
INSERT INTO CUSTOMERS VALUES('QUICK','QUICK-Stop','Horst Kloss','Accounting Manager','Taucherstra\u00dfe 10','Cunewalde',NULL,'01307','Germany','0372-035188',NULL)
INSERT INTO CUSTOMERS VALUES('RANCH','Rancho grande','Sergio Guti\u00e9rrez','Sales Representative','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina','(1) 123-5555','(1) 123-5556')
INSERT INTO CUSTOMERS VALUES('RATTC','Rattlesnake Canyon Grocery','Paula Wilson','Assistant Sales Representative','2817 Milton Dr.','Albuquerque','NM','87110','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('REGGC','Reggiani Caseifici','Maurizio Moroni','Sales Associate','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy','0522-556721','0522-556722')
INSERT INTO CUSTOMERS VALUES('RICAR','Ricardo Adocicados','Janete Limeira','Assistant Sales Agent','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil','(21) 555-3412',NULL)
INSERT INTO CUSTOMERS VALUES('RICSU','Richter Supermarkt','Michael Holz','Sales Manager','Grenzacherweg 237','Gen\u00e8ve',NULL,'1203','Switzerland','0897-034214',NULL)
INSERT INTO CUSTOMERS VALUES('ROMEY','Romero y tomillo','Alejandra Camino','Accounting Manager','Gran V\u00eda, 1','Madrid',NULL,'28001','Spain','(91) 745 6200','(91) 745 6210')
INSERT INTO CUSTOMERS VALUES('SANTG','Sant\u00e9 Gourmet','Jonas Bergulfsen','Owner','Erling Skakkes gate 78','Stavern',NULL,'4110','Norway','07-98 92 35','07-98 92 47')
INSERT INTO CUSTOMERS VALUES('SAVEA','Save-a-lot Markets','Jose Pavarotti','Sales Representative','187 Suffolk Ln.','Boise','ID','83720','USA','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('SEVES','Seven Seas Imports','Hari Kumar','Sales Manager','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('SIMOB','Simons bistro','Jytte Petersen','Owner','Vinb\u00e6ltet 34','K\u00f8benhavn',NULL,'1734','Denmark','31 12 34 56','31 13 35 57')
INSERT INTO CUSTOMERS VALUES('SPECD','Sp\u00e9cialit\u00e9s du monde','Dominique Perrier','Marketing Manager','25, rue Lauriston','Paris',NULL,'75016','France','(1) 47.55.60.10','(1) 47.55.60.20')
INSERT INTO CUSTOMERS VALUES('SPLIR','Split Rail Beer & Ale','Art Braunschweiger','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('SUPRD','Supr\u00eames d\u00e9lices','Pascale Cartrain','Accounting Manager','Boulevard Tirou, 255','Charleroi',NULL,'B-6000','Belgium','(071) 23 67 22 20','(071) 23 67 22 21')
INSERT INTO CUSTOMERS VALUES('THEBI','The Big Cheese','Liz Nixon','Marketing Manager','89 Jefferson Way\u000d\u000aSuite 2','Portland','OR','97201','USA','[phone]',NULL)
INSERT INTO CUSTOMERS VALUES('THECR','The Cracker Box','Liu Wong','Marketing Assistant','55 Grizzly Peak Rd.','Butte','MT','59801','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('TOMSP','Toms Spezialit\u00e4ten','Karin Josephs','Marketing Manager','Luisenstr. 48','M\u00fcnster',NULL,'44087','Germany','0251-031259','0251-035695')
INSERT INTO CUSTOMERS VALUES('TORTU','Tortuga Restaurante','Miguel Angel Paolino','Owner','Avda. Azteca 123','M\u00e9xico D.F.',NULL,'05033','Mexico','(5) 555-2933',NULL)
INSERT INTO CUSTOMERS VALUES('TRADH','Tradi\u00e7\u00e3o Hipermercados','Anabela Domingues','Sales Representative','Av. In\u00eas de Castro, 414','S\u00e3o Paulo','SP','05634-030','Brazil','(11) 555-2167','(11) 555-2168')
INSERT INTO CUSTOMERS VALUES('TRAIH','Trail''s Head Gourmet Provisioners','Helvetius Nagy','Sales Associate','722 DaVinci Blvd.','Kirkland','WA','98034','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('VAFFE','Vaffeljernet','Palle Ibsen','Sales Manager','Smagsl\u00f8get 45','\u00c5rhus',NULL,'8200','Denmark','86 21 32 43','86 22 33 44')
INSERT INTO CUSTOMERS VALUES('VICTE','Victuailles en stock','Mary Saveley','Sales Agent','2, rue du Commerce','Lyon',NULL,'69004','France','78.32.54.86','78.32.54.87')
INSERT INTO CUSTOMERS VALUES('VINET','Vins et alcools Chevalier','Paul Henriot','Accounting Manager','59 rue de l''Abbaye','Reims',NULL,'51100','France','26.47.15.10','26.47.15.11')
INSERT INTO CUSTOMERS VALUES('WANDK','Die Wandernde Kuh','Rita M\u00fcller','Sales Representative','Adenauerallee 900','Stuttgart',NULL,'70563','Germany','0711-020361','0711-035428')
INSERT INTO CUSTOMERS VALUES('WARTH','Wartian Herkku','Pirkko Koskitalo','Accounting Manager','Torikatu 38','Oulu',NULL,'90110','Finland','981-443655','981-443655')
INSERT INTO CUSTOMERS VALUES('WELLI','Wellington Importadora','Paula Parente','Sales Manager','Rua do Mercado, 12','Resende','SP','08737-363','Brazil','(14) 555-8122',NULL)
INSERT INTO CUSTOMERS VALUES('WHITC','White Clover Markets','Karl Jablonski','Owner','305 - 14th Ave. S.\u000d\u000aSuite 3B','Seattle','WA','98128','USA','[phone]','[phone]')
INSERT INTO CUSTOMERS VALUES('WILMK','Wilman Kala','Matti Karttunen','Owner/Marketing Assistant','Keskuskatu 45','Helsinki',NULL,'21240','Finland','90-224 8858','90-224 8858')
INSERT INTO CUSTOMERS VALUES('WOLZA','Wolski  Zajazd','Zbyszek Piestrzeniewicz','Owner','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland','(26) 642-7012','(26) 642-7012')
INSERT INTO EMPLOYEES VALUES(1,'Davolio','Nancy Ann','Sales Representative','Ms.','1948-12-08 00:00:00.0','1992-05-01 00:00:00.0','507 - 20th Ave. E.','Seattle','WA','98122','USA','[phone]','5467','Education includes a BA in Psychology from Colorado State University in 1970.  She also completed "The Art of the Cold Call."  Nancy is a member of Toastmasters International.',2)
INSERT INTO EMPLOYEES VALUES(2,'Fuller','Andrew','Vice President, Sales','Dr.','1952-02-19 00:00:00.0','1992-08-14 00:00:00.0','908 W. Capital Way','Tacoma','WA','98401','USA','[phone]','3457','Andrew received his BTS commercial in 1974 and a Ph.D. in International Marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993.  Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',NULL)
INSERT INTO EMPLOYEES VALUES(3,'Leverling','Janet','Sales Representative','Ms.','1963-08-30 00:00:00.0','1992-04-01 00:00:00.0','722 Moss Bay Blvd.','Kirkland','WA','98033','USA','[phone]','3355','Janet has a BS degree in Chemistry from Boston College (1984).  She has also completed a certificate program in Food Retailing Management.  Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.',2)
INSERT INTO EMPLOYEES VALUES(4,'Peacock','Margaret','Sales Representative','Mrs.','1937-09-19 00:00:00.0','1993-05-03 00:00:00.0','4110 Old Redmond Rd.','Redmond','WA','98052','USA','[phone]','5176','Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.',2)
INSERT INTO EMPLOYEES VALUES(5,'Buchanan','Steven','Sales Manager','Mr.','1955-03-04 00:00:00.0','1993-10-17 00:00:00.0','14 Garrett Hill','London',NULL,'SW1 8JR','UK','(71) 555-4848','3453','Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976.  Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London.  He was promoted to sales manager in March 1993.  Mr. Buchanan has completed courses in Successful Telemarketing and International Sales Management.  He is fluent in French.',2)
INSERT INTO EMPLOYEES VALUES(6,'Suyama','Michael','Sales Representative','Mr.','1963-07-02 00:00:00.0','1993-10-17 00:00:00.0','Coventry House\u000d\u000aMiner Rd.','London',NULL,'EC2 7JR','UK','(71) 555-7773','428','Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986).  He has also taken courses in Multi-Cultural Selling and Time Management for the Sales Professional.  He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',5)
INSERT INTO EMPLOYEES VALUES(7,'King','Robert','Sales Representative','Mr.','1960-05-29 00:00:00.0','1994-01-02 00:00:00.0','Edgeham Hollow\u000d\u000aWinchester Way','London',NULL,'RG1 9SP','UK','(71) 555-5598','465','Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company.  After completing a course entitled "Selling in Europe", he was transferred to the London office in March 1993.',5)
INSERT INTO EMPLOYEES VALUES(8,'Callahan','Laura','Inside Sales Coordinator','Ms.','1958-01-09 00:00:00.0','1994-03-05 00:00:00.0','4726 - 11th Ave. N.E.','Seattle','WA','98105','USA','[phone]','2344','Laura received a BA in psychology from the University of Washington.  She has also completed a course in business French.  She reads and writes French.',2)
INSERT INTO EMPLOYEES VALUES(9,'Dodsworth','Anne','Sales Representative','Ms.','1966-01-27 00:00:00.0','1994-11-15 00:00:00.0','7 Houndstooth Rd.','London',NULL,'WG2 7LT','UK','(71) 555-4444','452','Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.',5)
INSERT INTO ORDERDETAILS VALUES(10248,11,14.0,12,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10248,42,9.8,10,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10248,72,34.8,5,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10249,14,18.6,9,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10249,51,42.4,40,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10250,41,7.7,10,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10250,51,42.4,35,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10250,65,16.8,15,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10251,22,16.8,6,0.05E0)
INSERT INTO ORDERDETAILS VALUES(10251,57,15.6,15,0.05E0)
INSERT INTO ORDERDETAILS VALUES(10251,65,16.8,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10252,20,64.8,40,0.05E0)
INSERT INTO ORDERDETAILS VALUES(10252,33,2.0,25,0.05E0)
INSERT INTO ORDERDETAILS VALUES(10252,60,27.2,40,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10253,31,10.0,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10253,39,14.4,42,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10253,49,16.0,40,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10254,24,3.6,15,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10254,55,19.2,21,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10254,74,8.0,21,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10255,2,15.2,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10255,16,13.9,35,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10255,36,15.2,25,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10255,59,44.0,30,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10256,53,26.2,15,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10256,77,10.4,12,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10257,27,35.1,25,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10257,39,14.4,6,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10257,77,10.4,15,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10258,2,15.2,50,0.2E0)
INSERT INTO ORDERDETAILS VALUES(10258,5,17.0,65,0.2E0)
INSERT INTO ORDERDETAILS VALUES(10258,32,25.6,6,0.2E0)
INSERT INTO ORDERDETAILS VALUES(10259,21,8.0,10,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10259,37,20.8,1,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10260,41,7.7,16,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10260,57,15.6,50,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10260,62,39.4,15,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10260,70,12.0,21,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10261,21,8.0,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10261,35,14.4,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10262,5,17.0,12,0.2E0)
INSERT INTO ORDERDETAILS VALUES(10262,7,24.0,15,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10262,56,30.4,2,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10263,16,13.9,60,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10263,24,3.6,28,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10263,30,20.7,60,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10263,74,8.0,36,0.25E0)
INSERT INTO ORDERDETAILS VALUES(10264,2,15.2,35,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10264,41,7.7,25,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10265,17,31.2,30,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10265,70,12.0,20,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10266,12,30.4,12,0.05E0)
INSERT INTO ORDERDETAILS VALUES(10267,40,14.7,50,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10267,59,44.0,70,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10267,76,14.4,15,0.15E0)
INSERT INTO ORDERDETAILS VALUES(10268,29,99.0,10,0.0E0)
INSERT INTO ORDERDETAILS VALUES(10268,72,27.8,4,0.0E0)