Visa all information om alla anställda (employees).
9 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
| 2 | Fuller | Andrew | Vice President, Sales | Dr. | 1952-02-19 00:00:00 | 1992-08-14 00:00:00 | 908 W. Capital Way | Tacoma | WA | 98401 | USA | (206) 555-9482 | 3457 | img | img | http://accweb/emmployees/fuller.bmp | 2254.49 | |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1963-08-30 00:00:00 | 1992-04-01 00:00:00 | 722 Moss Bay Blvd. | Kirkland | WA | 98033 | USA | (206) 555-3412 | 3355 | img | img | 2 | http://accweb/emmployees/leverling.bmp | 3119.15 |
| 4 | Peacock | Margaret | Sales Representative | Mrs. | 1937-09-19 00:00:00 | 1993-05-03 00:00:00 | 4110 Old Redmond Rd. | Redmond | WA | 98052 | USA | (206) 555-8122 | 5176 | img | img | 2 | http://accweb/emmployees/peacock.bmp | 1861.08 |
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 | |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1958-01-09 00:00:00 | 1994-03-05 00:00:00 | 4726 - 11th Ave. N.E. | Seattle | WA | 98105 | USA | (206) 555-1189 | 2344 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2100.5 |
| 9 | Dodsworth | Anne | Sales Representative | Ms. | 1966-01-27 00:00:00 | 1994-11-15 00:00:00 | 7 Houndstooth Rd. | London | WG2 7LT | UK | (71) 555-4444 | 452 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2333.33 |
Visa för och efternamn (FirstName, Lastname) för alla anställda.
9 rader
| Firstname | Lastname |
|---|---|
| Nancy | Davolio |
| Andrew | Fuller |
| Janet | Leverling |
| Margaret | Peacock |
| Steven | Buchanan |
| Michael | Suyama |
| Robert | King |
| Laura | Callahan |
| Anne | Dodsworth |
Visa företagsnamnet (companyName) för alla leverantörer (Suppliers)
29 rader
| companyName |
|---|
| Aux joyeux ecclsiastiques |
| Bigfoot Breweries |
| Cooperativa de Quesos 'Las Cabras' |
| Escargots Nouveaux |
| Exotic Liquids |
| Formaggi Fortini s.r.l. |
| Forts d'rables |
| G'day, Mate |
| Gai pturage |
| Grandma Kelly's Homestead |
| Heli Swaren GmbH & Co. KG |
| Karkki Oy |
| Leka Trading |
| Lyngbysild |
| Ma Maison |
| Mayumi's |
| New England Seafood Cannery |
| New Orleans Cajun Delights |
| Nord-Ost-Fisch Handelsgesellschaft mbH |
| Norske Meierier |
| Pasta Buttini s.r.l. |
| Pavlova, Ltd. |
| PB Knckebrd AB |
| Plutzer Lebensmittelgromrkte AG |
| Refrescos Americanas LTDA |
| Specialty Biscuits, Ltd. |
| Svensk Sjfda AB |
| Tokyo Traders |
| Zaanse Snoepfabriek |
Visa alla information om den anställde med employeeID = 1.
1 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
Vem är kontaktperson på leverantören Tokyo Traders? (Supplier)
1 rader
| ContactName |
|---|
| Yoshi Nagase |
Vilka produkter (products) har ett pris (UnitPrice) som är exakt 10?
3 rader
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
|---|---|---|---|---|---|---|---|---|---|
| 3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10.0000 | 13 | 70 | 25 | 0 |
| 21 | Sir Rodney's Scones | 8 | 3 | 24 pkgs. x 4 pieces | 10.0000 | 3 | 40 | 5 | 0 |
| 74 | Longlife Tofu | 4 | 7 | 5 kg pkg. | 10.0000 | 4 | 20 | 5 | 0 |
Vilka produkter är slut på lager (UnitsInStock)?
5 rader
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
|---|---|---|---|---|---|---|---|---|---|
| 5 | Chef Anton's Gumbo Mix | 2 | 2 | 36 boxes | 21.3500 | 0 | 0 | 0 | 1 |
| 17 | Alice Mutton | 7 | 6 | 20 - 1 kg tins | 39.0000 | 0 | 0 | 0 | 1 |
| 29 | Thringer Rostbratwurst | 12 | 6 | 50 bags x 30 sausgs. | 123.7900 | 0 | 0 | 0 | 1 |
| 31 | Gorgonzola Telino | 14 | 4 | 12 - 100 g pkgs | 12.5000 | 0 | 70 | 20 | 0 |
| 53 | Perth Pasties | 24 | 6 | 48 pieces | 32.8000 | 0 | 0 | 0 | 1 |
Vilka produkter har lika många i lager (UnitsInStock) som beställningspunkt (ReOrderLevel)?
4 rader
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
|---|---|---|---|---|---|---|---|---|---|
| 5 | Chef Anton's Gumbo Mix | 2 | 2 | 36 boxes | 21.3500 | 0 | 0 | 0 | 1 |
| 17 | Alice Mutton | 7 | 6 | 20 - 1 kg tins | 39.0000 | 0 | 0 | 0 | 1 |
| 29 | Thringer Rostbratwurst | 12 | 6 | 50 bags x 30 sausgs. | 123.7900 | 0 | 0 | 0 | 1 |
| 53 | Perth Pasties | 24 | 6 | 48 pieces | 32.8000 | 0 | 0 | 0 | 1 |
Visa alla ordrar (orders) som har leverarats till Tyskland (Germany).
122 rader
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10249 | TOMSP | 6 | 1996-07-05 00:00:00 | 1996-08-16 00:00:00 | 1996-07-10 00:00:00 | 1 | 11.6100 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10260 | OTTIK | 4 | 1996-07-19 00:00:00 | 1996-08-16 00:00:00 | 1996-07-29 00:00:00 | 1 | 55.0900 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10267 | FRANK | 4 | 1996-07-29 00:00:00 | 1996-08-26 00:00:00 | 1996-08-06 00:00:00 | 1 | 208.5800 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10273 | QUICK | 3 | 1996-08-05 00:00:00 | 1996-09-02 00:00:00 | 1996-08-12 00:00:00 | 3 | 76.0700 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10277 | MORGK | 2 | 1996-08-09 00:00:00 | 1996-09-06 00:00:00 | 1996-08-13 00:00:00 | 3 | 125.7700 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | 4179 | Germany | |
| 10279 | LEHMS | 8 | 1996-08-13 00:00:00 | 1996-09-10 00:00:00 | 1996-08-16 00:00:00 | 2 | 25.8300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10284 | LEHMS | 4 | 1996-08-19 00:00:00 | 1996-09-16 00:00:00 | 1996-08-27 00:00:00 | 1 | 76.5600 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10285 | QUICK | 1 | 1996-08-20 00:00:00 | 1996-09-17 00:00:00 | 1996-08-26 00:00:00 | 2 | 76.8300 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10286 | QUICK | 8 | 1996-08-21 00:00:00 | 1996-09-18 00:00:00 | 1996-08-30 00:00:00 | 3 | 229.2400 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10301 | WANDK | 8 | 1996-09-09 00:00:00 | 1996-10-07 00:00:00 | 1996-09-17 00:00:00 | 2 | 45.0800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10312 | WANDK | 2 | 1996-09-23 00:00:00 | 1996-10-21 00:00:00 | 1996-10-03 00:00:00 | 2 | 40.2600 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10313 | QUICK | 2 | 1996-09-24 00:00:00 | 1996-10-22 00:00:00 | 1996-10-04 00:00:00 | 2 | 1.9600 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10323 | KOENE | 4 | 1996-10-07 00:00:00 | 1996-11-04 00:00:00 | 1996-10-14 00:00:00 | 1 | 4.8800 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10325 | KOENE | 1 | 1996-10-09 00:00:00 | 1996-10-23 00:00:00 | 1996-10-14 00:00:00 | 3 | 64.8600 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10337 | FRANK | 4 | 1996-10-24 00:00:00 | 1996-11-21 00:00:00 | 1996-10-29 00:00:00 | 3 | 108.2600 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10342 | FRANK | 4 | 1996-10-30 00:00:00 | 1996-11-13 00:00:00 | 1996-11-04 00:00:00 | 2 | 54.8300 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10343 | LEHMS | 4 | 1996-10-31 00:00:00 | 1996-11-28 00:00:00 | 1996-11-06 00:00:00 | 1 | 110.3700 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10345 | QUICK | 2 | 1996-11-04 00:00:00 | 1996-12-02 00:00:00 | 1996-11-11 00:00:00 | 2 | 249.0600 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10348 | WANDK | 4 | 1996-11-07 00:00:00 | 1996-12-05 00:00:00 | 1996-11-15 00:00:00 | 2 | 0.7800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10356 | WANDK | 6 | 1996-11-18 00:00:00 | 1996-12-16 00:00:00 | 1996-11-27 00:00:00 | 2 | 36.7100 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10361 | QUICK | 1 | 1996-11-22 00:00:00 | 1996-12-20 00:00:00 | 1996-12-03 00:00:00 | 2 | 183.1700 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10363 | DRACD | 4 | 1996-11-26 00:00:00 | 1996-12-24 00:00:00 | 1996-12-04 00:00:00 | 3 | 30.5400 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 10391 | DRACD | 3 | 1996-12-23 00:00:00 | 1997-01-20 00:00:00 | 1996-12-31 00:00:00 | 3 | 5.4500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 10396 | FRANK | 1 | 1996-12-27 00:00:00 | 1997-01-10 00:00:00 | 1997-01-06 00:00:00 | 3 | 135.3500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10407 | OTTIK | 2 | 1997-01-07 00:00:00 | 1997-02-04 00:00:00 | 1997-01-30 00:00:00 | 2 | 91.4800 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10418 | QUICK | 4 | 1997-01-17 00:00:00 | 1997-02-14 00:00:00 | 1997-01-24 00:00:00 | 1 | 17.5500 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10438 | TOMSP | 3 | 1997-02-06 00:00:00 | 1997-03-06 00:00:00 | 1997-02-14 00:00:00 | 2 | 8.2400 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10446 | TOMSP | 6 | 1997-02-14 00:00:00 | 1997-03-14 00:00:00 | 1997-02-19 00:00:00 | 1 | 14.6800 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10451 | QUICK | 4 | 1997-02-19 00:00:00 | 1997-03-05 00:00:00 | 1997-03-12 00:00:00 | 3 | 189.0900 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10456 | KOENE | 8 | 1997-02-25 00:00:00 | 1997-04-08 00:00:00 | 1997-02-28 00:00:00 | 2 | 8.1200 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10457 | KOENE | 2 | 1997-02-25 00:00:00 | 1997-03-25 00:00:00 | 1997-03-03 00:00:00 | 1 | 11.5700 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10468 | KOENE | 3 | 1997-03-07 00:00:00 | 1997-04-04 00:00:00 | 1997-03-12 00:00:00 | 3 | 44.1200 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10488 | FRANK | 8 | 1997-03-27 00:00:00 | 1997-04-24 00:00:00 | 1997-04-02 00:00:00 | 2 | 4.9300 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10497 | LEHMS | 7 | 1997-04-04 00:00:00 | 1997-05-02 00:00:00 | 1997-04-07 00:00:00 | 1 | 36.2100 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10501 | BLAUS | 9 | 1997-04-09 00:00:00 | 1997-05-07 00:00:00 | 1997-04-16 00:00:00 | 3 | 8.8500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10506 | KOENE | 9 | 1997-04-15 00:00:00 | 1997-05-13 00:00:00 | 1997-05-02 00:00:00 | 2 | 21.1900 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10508 | OTTIK | 1 | 1997-04-16 00:00:00 | 1997-05-14 00:00:00 | 1997-05-13 00:00:00 | 2 | 4.9900 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10509 | BLAUS | 4 | 1997-04-17 00:00:00 | 1997-05-15 00:00:00 | 1997-04-29 00:00:00 | 1 | 0.1500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10513 | WANDK | 7 | 1997-04-22 00:00:00 | 1997-06-03 00:00:00 | 1997-04-28 00:00:00 | 1 | 105.6500 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10515 | QUICK | 2 | 1997-04-23 00:00:00 | 1997-05-07 00:00:00 | 1997-05-23 00:00:00 | 1 | 204.4700 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10522 | LEHMS | 4 | 1997-04-30 00:00:00 | 1997-05-28 00:00:00 | 1997-05-06 00:00:00 | 1 | 45.3300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10527 | QUICK | 7 | 1997-05-05 00:00:00 | 1997-06-02 00:00:00 | 1997-05-07 00:00:00 | 1 | 41.9000 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10534 | LEHMS | 8 | 1997-05-12 00:00:00 | 1997-06-09 00:00:00 | 1997-05-14 00:00:00 | 2 | 27.9400 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10536 | LEHMS | 3 | 1997-05-14 00:00:00 | 1997-06-11 00:00:00 | 1997-06-06 00:00:00 | 2 | 58.8800 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10540 | QUICK | 3 | 1997-05-19 00:00:00 | 1997-06-16 00:00:00 | 1997-06-13 00:00:00 | 3 | 1007.6400 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10542 | KOENE | 1 | 1997-05-20 00:00:00 | 1997-06-17 00:00:00 | 1997-05-26 00:00:00 | 3 | 10.9500 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10548 | TOMSP | 3 | 1997-05-26 00:00:00 | 1997-06-23 00:00:00 | 1997-06-02 00:00:00 | 2 | 1.4300 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10549 | QUICK | 5 | 1997-05-27 00:00:00 | 1997-06-10 00:00:00 | 1997-05-30 00:00:00 | 1 | 171.2400 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10554 | OTTIK | 4 | 1997-05-30 00:00:00 | 1997-06-27 00:00:00 | 1997-06-05 00:00:00 | 3 | 120.9700 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10557 | LEHMS | 9 | 1997-06-03 00:00:00 | 1997-06-17 00:00:00 | 1997-06-06 00:00:00 | 2 | 96.7200 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10560 | FRANK | 8 | 1997-06-06 00:00:00 | 1997-07-04 00:00:00 | 1997-06-09 00:00:00 | 1 | 36.6500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10575 | MORGK | 5 | 1997-06-20 00:00:00 | 1997-07-04 00:00:00 | 1997-06-30 00:00:00 | 1 | 127.3400 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | 4179 | Germany | |
| 10580 | OTTIK | 4 | 1997-06-26 00:00:00 | 1997-07-24 00:00:00 | 1997-07-01 00:00:00 | 3 | 75.8900 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10582 | BLAUS | 3 | 1997-06-27 00:00:00 | 1997-07-25 00:00:00 | 1997-07-14 00:00:00 | 2 | 27.7100 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10588 | QUICK | 2 | 1997-07-03 00:00:00 | 1997-07-31 00:00:00 | 1997-07-10 00:00:00 | 3 | 194.6700 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10592 | LEHMS | 3 | 1997-07-08 00:00:00 | 1997-08-05 00:00:00 | 1997-07-16 00:00:00 | 1 | 32.1000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10593 | LEHMS | 7 | 1997-07-09 00:00:00 | 1997-08-06 00:00:00 | 1997-08-13 00:00:00 | 2 | 174.2000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10608 | TOMSP | 4 | 1997-07-23 00:00:00 | 1997-08-20 00:00:00 | 1997-08-01 00:00:00 | 2 | 27.7900 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10614 | BLAUS | 8 | 1997-07-29 00:00:00 | 1997-08-26 00:00:00 | 1997-08-01 00:00:00 | 3 | 1.9300 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10623 | FRANK | 8 | 1997-08-07 00:00:00 | 1997-09-04 00:00:00 | 1997-08-12 00:00:00 | 2 | 97.1800 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10630 | KOENE | 1 | 1997-08-13 00:00:00 | 1997-09-10 00:00:00 | 1997-08-19 00:00:00 | 2 | 32.3500 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10632 | WANDK | 8 | 1997-08-14 00:00:00 | 1997-09-11 00:00:00 | 1997-08-19 00:00:00 | 1 | 41.3800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10640 | WANDK | 4 | 1997-08-21 00:00:00 | 1997-09-18 00:00:00 | 1997-08-28 00:00:00 | 1 | 23.5500 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10643 | ALFKI | 6 | 1997-08-25 00:00:00 | 1997-09-22 00:00:00 | 1997-09-02 00:00:00 | 1 | 29.4600 | Alfreds Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 10651 | WANDK | 8 | 1997-09-01 00:00:00 | 1997-09-29 00:00:00 | 1997-09-11 00:00:00 | 2 | 20.6000 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10653 | FRANK | 1 | 1997-09-02 00:00:00 | 1997-09-30 00:00:00 | 1997-09-19 00:00:00 | 1 | 93.2500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10658 | QUICK | 4 | 1997-09-05 00:00:00 | 1997-10-03 00:00:00 | 1997-09-08 00:00:00 | 1 | 364.1500 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10668 | WANDK | 1 | 1997-09-15 00:00:00 | 1997-10-13 00:00:00 | 1997-09-23 00:00:00 | 2 | 47.2200 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 10670 | FRANK | 4 | 1997-09-16 00:00:00 | 1997-10-14 00:00:00 | 1997-09-18 00:00:00 | 1 | 203.4800 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10675 | FRANK | 5 | 1997-09-19 00:00:00 | 1997-10-17 00:00:00 | 1997-09-23 00:00:00 | 2 | 31.8500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10684 | OTTIK | 3 | 1997-09-26 00:00:00 | 1997-10-24 00:00:00 | 1997-09-30 00:00:00 | 1 | 145.6300 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10691 | QUICK | 2 | 1997-10-03 00:00:00 | 1997-11-14 00:00:00 | 1997-10-22 00:00:00 | 2 | 810.0500 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10692 | ALFKI | 4 | 1997-10-03 00:00:00 | 1997-10-31 00:00:00 | 1997-10-13 00:00:00 | 2 | 61.0200 | Alfred-s Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 10694 | QUICK | 8 | 1997-10-06 00:00:00 | 1997-11-03 00:00:00 | 1997-10-09 00:00:00 | 3 | 398.3600 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10699 | MORGK | 3 | 1997-10-09 00:00:00 | 1997-11-06 00:00:00 | 1997-10-13 00:00:00 | 3 | 0.5800 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | 4179 | Germany | |
| 10702 | ALFKI | 4 | 1997-10-13 00:00:00 | 1997-11-24 00:00:00 | 1997-10-21 00:00:00 | 1 | 23.9400 | Alfred-s Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 10717 | FRANK | 1 | 1997-10-24 00:00:00 | 1997-11-21 00:00:00 | 1997-10-29 00:00:00 | 2 | 59.2500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10718 | KOENE | 1 | 1997-10-27 00:00:00 | 1997-11-24 00:00:00 | 1997-10-29 00:00:00 | 3 | 170.8800 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10721 | QUICK | 5 | 1997-10-29 00:00:00 | 1997-11-26 00:00:00 | 1997-10-31 00:00:00 | 3 | 48.9200 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10745 | QUICK | 9 | 1997-11-18 00:00:00 | 1997-12-16 00:00:00 | 1997-11-27 00:00:00 | 1 | 3.5200 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10765 | QUICK | 3 | 1997-12-04 00:00:00 | 1998-01-01 00:00:00 | 1997-12-09 00:00:00 | 3 | 42.7400 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10766 | OTTIK | 4 | 1997-12-05 00:00:00 | 1998-01-02 00:00:00 | 1997-12-09 00:00:00 | 1 | 157.5500 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10772 | LEHMS | 3 | 1997-12-10 00:00:00 | 1998-01-07 00:00:00 | 1997-12-19 00:00:00 | 2 | 91.2800 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10779 | MORGK | 3 | 1997-12-16 00:00:00 | 1998-01-13 00:00:00 | 1998-01-14 00:00:00 | 2 | 58.1300 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | 4179 | Germany | |
| 10788 | QUICK | 1 | 1997-12-22 00:00:00 | 1998-01-19 00:00:00 | 1998-01-19 00:00:00 | 2 | 42.7000 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10791 | FRANK | 6 | 1997-12-23 00:00:00 | 1998-01-20 00:00:00 | 1998-01-01 00:00:00 | 2 | 16.8500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10797 | DRACD | 7 | 1997-12-25 00:00:00 | 1998-01-22 00:00:00 | 1998-01-05 00:00:00 | 2 | 33.3500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 10799 | KOENE | 9 | 1997-12-26 00:00:00 | 1998-02-06 00:00:00 | 1998-01-05 00:00:00 | 3 | 30.7600 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10817 | KOENE | 3 | 1998-01-06 00:00:00 | 1998-01-20 00:00:00 | 1998-01-13 00:00:00 | 2 | 306.0700 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10825 | DRACD | 1 | 1998-01-09 00:00:00 | 1998-02-06 00:00:00 | 1998-01-14 00:00:00 | 1 | 79.2500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 10833 | OTTIK | 6 | 1998-01-15 00:00:00 | 1998-02-12 00:00:00 | 1998-01-23 00:00:00 | 2 | 71.4900 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 10835 | ALFKI | 1 | 1998-01-15 00:00:00 | 1998-02-12 00:00:00 | 1998-01-21 00:00:00 | 3 | 69.5300 | Alfred-s Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 10845 | QUICK | 8 | 1998-01-21 00:00:00 | 1998-02-04 00:00:00 | 1998-01-30 00:00:00 | 1 | 212.9800 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10849 | KOENE | 9 | 1998-01-23 00:00:00 | 1998-02-20 00:00:00 | 1998-01-30 00:00:00 | 2 | 0.5600 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10853 | BLAUS | 9 | 1998-01-27 00:00:00 | 1998-02-24 00:00:00 | 1998-02-03 00:00:00 | 2 | 53.8300 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10859 | FRANK | 1 | 1998-01-29 00:00:00 | 1998-02-26 00:00:00 | 1998-02-02 00:00:00 | 2 | 76.1000 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10862 | LEHMS | 8 | 1998-01-30 00:00:00 | 1998-03-13 00:00:00 | 1998-02-02 00:00:00 | 2 | 53.2300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10865 | QUICK | 2 | 1998-02-02 00:00:00 | 1998-02-16 00:00:00 | 1998-02-12 00:00:00 | 1 | 348.1400 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10878 | QUICK | 4 | 1998-02-10 00:00:00 | 1998-03-10 00:00:00 | 1998-02-12 00:00:00 | 1 | 46.6900 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10891 | LEHMS | 7 | 1998-02-17 00:00:00 | 1998-03-17 00:00:00 | 1998-02-19 00:00:00 | 2 | 20.3700 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10893 | KOENE | 9 | 1998-02-18 00:00:00 | 1998-03-18 00:00:00 | 1998-02-20 00:00:00 | 2 | 77.7800 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 10929 | FRANK | 6 | 1998-03-05 00:00:00 | 1998-04-02 00:00:00 | 1998-03-12 00:00:00 | 1 | 33.9300 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 10934 | LEHMS | 3 | 1998-03-09 00:00:00 | 1998-04-06 00:00:00 | 1998-03-12 00:00:00 | 3 | 32.0100 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | |
| 10938 | QUICK | 3 | 1998-03-10 00:00:00 | 1998-04-07 00:00:00 | 1998-03-16 00:00:00 | 2 | 31.8900 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10945 | MORGK | 4 | 1998-03-12 00:00:00 | 1998-04-09 00:00:00 | 1998-03-18 00:00:00 | 1 | 10.2200 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | 4179 | Germany | |
| 10952 | ALFKI | 1 | 1998-03-16 00:00:00 | 1998-04-27 00:00:00 | 1998-03-24 00:00:00 | 1 | 40.4200 | Alfred-s Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 10956 | BLAUS | 6 | 1998-03-17 00:00:00 | 1998-04-28 00:00:00 | 1998-03-20 00:00:00 | 2 | 44.6500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | |
| 10962 | QUICK | 8 | 1998-03-19 00:00:00 | 1998-04-16 00:00:00 | 1998-03-23 00:00:00 | 2 | 275.7900 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10967 | TOMSP | 2 | 1998-03-23 00:00:00 | 1998-04-20 00:00:00 | 1998-04-02 00:00:00 | 2 | 62.2200 | Toms Spezialitten | Luisenstr. 48 | Mnster | 44087 | Germany | |
| 10991 | QUICK | 1 | 1998-04-01 00:00:00 | 1998-04-29 00:00:00 | 1998-04-07 00:00:00 | 1 | 38.5100 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10996 | QUICK | 4 | 1998-04-02 00:00:00 | 1998-04-30 00:00:00 | 1998-04-10 00:00:00 | 2 | 1.1200 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 10999 | OTTIK | 6 | 1998-04-03 00:00:00 | 1998-05-01 00:00:00 | 1998-04-10 00:00:00 | 2 | 96.3500 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 11011 | ALFKI | 3 | 1998-04-09 00:00:00 | 1998-05-07 00:00:00 | 1998-04-13 00:00:00 | 1 | 1.2100 | Alfred-s Futterkiste | Obere Str. 57 | Berlin | 12209 | Germany | |
| 11012 | FRANK | 1 | 1998-04-09 00:00:00 | 1998-04-23 00:00:00 | 1998-04-17 00:00:00 | 3 | 242.9500 | Frankenversand | Berliner Platz 43 | Mnchen | 80805 | Germany | |
| 11020 | OTTIK | 2 | 1998-04-14 00:00:00 | 1998-05-12 00:00:00 | 1998-04-16 00:00:00 | 2 | 43.3000 | Ottilies Kseladen | Mehrheimerstr. 369 | Kln | 50739 | Germany | |
| 11021 | QUICK | 3 | 1998-04-14 00:00:00 | 1998-05-12 00:00:00 | 1998-04-21 00:00:00 | 1 | 297.1800 | QUICK-Stop | Taucherstrae 10 | Cunewalde | 1307 | Germany | |
| 11028 | KOENE | 2 | 1998-04-16 00:00:00 | 1998-05-14 00:00:00 | 1998-04-22 00:00:00 | 1 | 29.5900 | Kniglich Essen | Maubelstr. 90 | Brandenburg | 14776 | Germany | |
| 11036 | DRACD | 8 | 1998-04-20 00:00:00 | 1998-05-18 00:00:00 | 1998-04-22 00:00:00 | 3 | 149.4700 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 11046 | WANDK | 8 | 1998-04-23 00:00:00 | 1998-05-21 00:00:00 | 1998-04-24 00:00:00 | 2 | 71.6400 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | 70563 | Germany | |
| 11058 | BLAUS | 9 | 1998-04-29 00:00:00 | 1998-05-27 00:00:00 | 3 | 31.1400 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | 68306 | Germany | ||
| 11067 | DRACD | 1 | 1998-05-04 00:00:00 | 1998-05-18 00:00:00 | 1998-05-06 00:00:00 | 2 | 7.9800 | Drachenblut Delikatessen | Walserweg 21 | Aachen | 52066 | Germany | |
| 11070 | LEHMS | 2 | 1998-05-05 00:00:00 | 1998-06-02 00:00:00 | 1 | 136.0000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany |
Visa de städer där de anställda arbetar, varje stad skall bara visas en gång.
5 rader
| City |
|---|
| Seattle |
| Tacoma |
| Kirkland |
| Redmond |
| London |
Visa all information om de anställda i alfabetisk ordning
9 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1958-01-09 00:00:00 | 1994-03-05 00:00:00 | 4726 - 11th Ave. N.E. | Seattle | WA | 98105 | USA | (206) 555-1189 | 2344 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2100.5 |
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
| 9 | Dodsworth | Anne | Sales Representative | Ms. | 1966-01-27 00:00:00 | 1994-11-15 00:00:00 | 7 Houndstooth Rd. | London | WG2 7LT | UK | (71) 555-4444 | 452 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2333.33 | |
| 2 | Fuller | Andrew | Vice President, Sales | Dr. | 1952-02-19 00:00:00 | 1992-08-14 00:00:00 | 908 W. Capital Way | Tacoma | WA | 98401 | USA | (206) 555-9482 | 3457 | img | img | http://accweb/emmployees/fuller.bmp | 2254.49 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 | |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1963-08-30 00:00:00 | 1992-04-01 00:00:00 | 722 Moss Bay Blvd. | Kirkland | WA | 98033 | USA | (206) 555-3412 | 3355 | img | img | 2 | http://accweb/emmployees/leverling.bmp | 3119.15 |
| 4 | Peacock | Margaret | Sales Representative | Mrs. | 1937-09-19 00:00:00 | 1993-05-03 00:00:00 | 4110 Old Redmond Rd. | Redmond | WA | 98052 | USA | (206) 555-8122 | 5176 | img | img | 2 | http://accweb/emmployees/peacock.bmp | 1861.08 |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 |
Visa all information om de anställda, visa resultatet sorterat i åldersordning, äldst först
9 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | Peacock | Margaret | Sales Representative | Mrs. | 1937-09-19 00:00:00 | 1993-05-03 00:00:00 | 4110 Old Redmond Rd. | Redmond | WA | 98052 | USA | (206) 555-8122 | 5176 | img | img | 2 | http://accweb/emmployees/peacock.bmp | 1861.08 |
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
| 2 | Fuller | Andrew | Vice President, Sales | Dr. | 1952-02-19 00:00:00 | 1992-08-14 00:00:00 | 908 W. Capital Way | Tacoma | WA | 98401 | USA | (206) 555-9482 | 3457 | img | img | http://accweb/emmployees/fuller.bmp | 2254.49 | |
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1958-01-09 00:00:00 | 1994-03-05 00:00:00 | 4726 - 11th Ave. N.E. | Seattle | WA | 98105 | USA | (206) 555-1189 | 2344 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2100.5 |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1963-08-30 00:00:00 | 1992-04-01 00:00:00 | 722 Moss Bay Blvd. | Kirkland | WA | 98033 | USA | (206) 555-3412 | 3355 | img | img | 2 | http://accweb/emmployees/leverling.bmp | 3119.15 |
| 9 | Dodsworth | Anne | Sales Representative | Ms. | 1966-01-27 00:00:00 | 1994-11-15 00:00:00 | 7 Houndstooth Rd. | London | WG2 7LT | UK | (71) 555-4444 | 452 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2333.33 |
Visa all information om kunderna (customer), sortera i första hand efter land och i andra hand efter stad
93 rader
| CustomerID | CompanyName | ContactName | ContactTitle | Address | City | Region | PostalCode | Country | Phone | Fax |
|---|---|---|---|---|---|---|---|---|---|---|
| VALON | IT | Valon Hoti | IT | |||||||
| Val2 | IT | Val2 | IT | |||||||
| CACTU | Cactus Comidas para llevar | Patricio Simpson | Sales Agent | Cerrito 333 | Buenos Aires | 1010 | Argentina | (1) 135-5555 | (1) 135-4892 | |
| OCEAN | Ocano Atlntico Ltda. | Yvonne Moncada | Sales Agent | Ing. Gustavo Moncada 8585 Piso 20-A | Buenos Aires | 1010 | Argentina | (1) 135-5333 | (1) 135-5535 | |
| RANCH | Rancho grande | Sergio Gutirrez | Sales Representative | Av. del Libertador 900 | Buenos Aires | 1010 | Argentina | (1) 123-5555 | (1) 123-5556 | |
| ERNSH | Ernst Handel | Roland Mendel | Sales Manager | Kirchgasse 6 | Graz | 8010 | Austria | 7675-3425 | 7675-3426 | |
| PICCO | Piccolo und mehr | Georg Pipps | Sales Manager | Geislweg 14 | Salzburg | 5020 | Austria | 6562-9722 | 6562-9723 | |
| MAISD | Maison Dewey | Catherine Dewey | Sales Agent | Rue Joseph-Bens 532 | Bruxelles | B-1180 | Belgium | (02) 201 24 67 | (02) 201 24 68 | |
| SUPRD | Suprmes dlices | Pascale Cartrain | Accounting Manager | Boulevard Tirou, 255 | Charleroi | B-6000 | Belgium | (071) 23 67 22 20 | (071) 23 67 22 21 | |
| GOURL | Gourmet Lanchonetes | Andr Fonseca | Sales Associate | Av. Brasil, 442 | Campinas | SP | 04876-786 | Brazil | (11) 555-9482 | |
| WELLI | Wellington Importadora | Paula Parente | Sales Manager | Rua do Mercado, 12 | Resende | SP | 08737-363 | Brazil | (14) 555-8122 | |
| HANAR | Hanari Carnes | Mario Pontes | Accounting Manager | Rua do Pao, 67 | Rio de Janeiro | RJ | 05454-876 | Brazil | (21) 555-0091 | (21) 555-8765 |
| QUEDE | Que Delcia | Bernardo Batista | Accounting Manager | Rua da Panificadora, 12 | Rio de Janeiro | RJ | 02389-673 | Brazil | (21) 555-4252 | (21) 555-4545 |
| RICAR | Ricardo Adocicados | Janete Limeira | Assistant Sales Agent | Av. Copacabana, 267 | Rio de Janeiro | RJ | 02389-890 | Brazil | (21) 555-3412 | |
| COMMI | Comrcio Mineiro | Pedro Afonso | Sales Associate | Av. dos Lusadas, 23 | Sao Paulo | SP | 05432-043 | Brazil | (11) 555-7647 | |
| FAMIA | Familia Arquibaldo | Aria Cruz | Marketing Assistant | Rua Ors, 92 | Sao Paulo | SP | 05442-030 | Brazil | (11) 555-9857 | |
| QUEEN | Queen Cozinha | Lcia Carvalho | Marketing Assistant | Alameda dos Canrios, 891 | Sao Paulo | SP | 05487-020 | Brazil | (11) 555-1189 | |
| TRADH | Tradio Hipermercados | Anabela Domingues | Sales Representative | Av. Ins de Castro, 414 | Sao Paulo | SP | 05634-030 | Brazil | (11) 555-2167 | (11) 555-2168 |
| MEREP | Mre Paillarde | Jean Fresnire | Marketing Assistant | 43 rue St. Laurent | Montral | Qubec | H1J 1C3 | Canada | (514) 555-8054 | (514) 555-8055 |
| BOTTM | Bottom-Dollar Markets | Elizabeth Lincoln | Accounting Manager | 23 Tsawassen Blvd. | Tsawassen | BC | T2F 8M4 | Canada | (604) 555-4729 | (604) 555-3745 |
| LAUGB | Laughing Bacchus Wine Cellars | Yoshi Tannamuri | Marketing Assistant | 1900 Oak St. | Vancouver | BC | V3F 2K1 | Canada | (604) 555-3392 | (604) 555-7293 |
| SIMOB | Simons bistro | Jytte Petersen | Owner | Vinbltet 34 | Kobenhavn | 1734 | Denmark | 31 12 34 56 | 31 13 35 57 | |
| VAFFE | Vaffeljernet | Palle Ibsen | Sales Manager | Smagsloget 45 | rhus | 8200 | Denmark | 86 21 32 43 | 86 22 33 44 | |
| WILMK | Wilman Kala | Matti Karttunen | Owner/Marketing Assistant | Keskuskatu 45 | Helsinki | 21240 | Finland | 90-224 8858 | 90-224 8858 | |
| WARTH | Wartian Herkku | Pirkko Koskitalo | Accounting Manager | Torikatu 38 | Oulu | 90110 | Finland | 981-443655 | 981-443655 | |
| FOLIG | Folies gourmandes | Martine Ranc | Assistant Sales Agent | 184, chausse de Tournai | Lille | 59000 | France | 20.16.10.16 | 20.16.10.17 | |
| VICTE | Victuailles en stock | Mary Saveley | Sales Agent | 2, rue du Commerce | Lyon | 69004 | France | 78.32.54.86 | 78.32.54.87 | |
| BONAP | Bon app' | Laurence Lebihan | Owner | 12, rue des Bouchers | Marseille | 13008 | France | 91.24.45.40 | 91.24.45.41 | |
| DUMON | Du monde entier | Janine Labrune | Owner | 67, rue des Cinquante Otages | Nantes | 44000 | France | 40.67.88.88 | 40.67.89.89 | |
| FRANR | France restauration | Carine Schmitt | Marketing Manager | 54, rue Royale | Nantes | 44000 | France | 40.32.21.21 | 40.32.21.20 | |
| PARIS | Paris spcialits | Marie Bertrand | Owner | 265, boulevard Charonne | Paris | 75012 | France | (1) 42.34.22.66 | (1) 42.34.22.77 | |
| SPECD | Spcialits du monde | Dominique Perrier | Marketing Manager | 25, rue Lauriston | Paris | 75016 | France | (1) 47.55.60.10 | (1) 47.55.60.20 | |
| VINET | Vins et alcools Chevalier | Paul Henriot | Accounting Manager | 59 rue de l'Abbaye | Reims | 51100 | France | 26.47.15.10 | 26.47.15.11 | |
| BLONP | Blondesddsl pre et fils | Frdrique Citeaux | Marketing Manager | 24, place Klber | Strasbourg | 67000 | France | 88.60.15.31 | 88.60.15.32 | |
| LAMAI | La maison d'Asie | Annette Roulet | Sales Manager | 1 rue Alsace-Lorraine | Toulouse | 31000 | France | 61.77.61.10 | 61.77.61.11 | |
| LACOR | La corne d'abondance | Daniel Tonini | Sales Representative | 67, avenue de l'Europe | Versailles | 78000 | France | 30.59.84.10 | 30.59.85.11 | |
| DRACD | Drachenblut Delikatessen | Sven Ottlieb | Order Administrator | Walserweg 21 | Aachen | 52066 | Germany | 0241-039123 | 0241-059428 | |
| ALFKI | Alfreds Futterkiste | Maria Anders | Sales Representative | Obere Str. 57 | Berlin | 12209 | Germany | 030-0074321 | 030-0076545 | |
| KOENE | Kniglich Essen | Philip Cramer | Sales Associate | Maubelstr. 90 | Brandenburg | 14776 | Germany | 0555-09876 | ||
| QUICK | QUICK-Stop | Horst Kloss | Accounting Manager | Taucherstrae 10 | Cunewalde | 01307 | Germany | 0372-035188 | ||
| LEHMS | Lehmanns Marktstand | Renate Messner | Sales Representative | Magazinweg 7 | Frankfurt a.M. | 60528 | Germany | 069-0245984 | 069-0245874 | |
| OTTIK | Ottilies Kseladen | Henriette Pfalzheim | Owner | Mehrheimerstr. 369 | Kln | 50739 | Germany | 0221-0644327 | 0221-0765721 | |
| MORGK | Morgenstern Gesundkost | Alexander Feuer | Marketing Assistant | Heerstr. 22 | Leipzig | 04179 | Germany | 0342-023176 | ||
| BLAUS | Blauer See Delikatessen | Hanna Moos | Sales Representative | Forsterstr. 57 | Mannheim | 68306 | Germany | 0621-08460 | 0621-08924 | |
| FRANK | Frankenversand | Peter Franken | Marketing Manager | Berliner Platz 43 | Mnchen | 80805 | Germany | 089-0877310 | 089-0877451 | |
| TOMSP | Toms Spezialitten | Karin Josephs | Marketing Manager | Luisenstr. 48 | Mnster | 44087 | Germany | 0251-031259 | 0251-035695 | |
| WANDK | Die Wandernde Kuh | Rita Mller | Sales Representative | Adenauerallee 900 | Stuttgart | 70563 | Germany | 0711-020361 | 0711-035428 | |
| HUNGO | Hungry Owl All-Night Grocers | Patricia McKenna | Sales Associate | 8 Johnstown Road | Cork | Co. Cork | Ireland | 2967 542 | 2967 3333 | |
| MAGAA | Magazzini Alimentari Riuniti | Giovanni Rovelli | Marketing Manager | Via Ludovico il Moro 22 | Bergamo | 24100 | Italy | 035-640230 | 035-640231 | |
| REGGC | Reggiani Caseifici | Maurizio Moroni | Sales Associate | Strada Provinciale 124 | Reggio Emilia | 42100 | Italy | 0522-556721 | 0522-556722 | |
| FRANS | Franchi S.p.A. | Paolo Accorti | Sales Representative | Via Monte Bianco 34 | Torino | 10100 | Italy | 011-4988260 | 011-4988261 | |
| ANATR | Ana Trujillo Emparedados y helados | Ana Trujillo | Owner | Avda. de la Constitucin 2222 | Mxico D.F. | 05021 | Mexico | (5) 555-4729 | (5) 555-3745 | |
| ANTON | Antonio Moreno Taquera | Antonio Moreno | Owner | Mataderos 2312 | Mxico D.F. | 05023 | Mexico | (5) 555-3932 | ||
| CENTC | Centro comercial Moctezuma | Francisco Chang | Marketing Manager | Sierras de Granada 9993 | Mxico D.F. | 05022 | Mexico | (5) 555-3392 | (5) 555-7293 | |
| PERIC | Pericles Comidas clsicas | Guillermo Fernndez | Sales Representative | Calle Dr. Jorge Cash 321 | Mxico D.F. | 05033 | Mexico | (5) 552-3745 | (5) 545-3745 | |
| TORTU | Tortuga Restaurante | Miguel Angel Paolino | Owner | Avda. Azteca 123 | Mxico D.F. | 05033 | Mexico | (5) 555-2933 | ||
| SANTG | Sant Gourmet | Jonas Bergulfsen | Owner | Erling Skakkes gate 78 | Stavern | 4110 | Norway | 07-98 92 35 | 07-98 92 47 | |
| WOLZA | Wolski Zajazd | Zbyszek Piestrzeniewicz | Owner | ul. Filtrowa 68 | Warszawa | 01-012 | Poland | (26) 642-7012 | (26) 642-7012 | |
| FURIB | Furia Bacalhau e Frutos do Mar | Lino Rodriguez | Sales Manager | Jardim das rosas n. 32 | Lisboa | 1675 | Portugal | (1) 354-2534 | (1) 354-2535 | |
| PRINI | Princesa Isabel Vinhos | Isabel de Castro | Sales Representative | Estrada da sade n. 58 | Lisboa | 1756 | Portugal | (1) 356-5634 | ||
| GALED | Galera del gastrnomo | Eduardo Saavedra | Marketing Manager | Rambla de Catalua, 23 | Barcelona | 08022 | Spain | (93) 203 4560 | (93) 203 4561 | |
| BOLID | Blido Comidas preparadas | Martn Sommer | Owner | C/ Araquil, 67 | Madrid | 28023 | Spain | (91) 555 22 82 | (91) 555 91 99 | |
| FISSA | FISSA Fabrica Inter. Salchichas S.A. | Diego Roel | Accounting Manager | C/ Moralzarzal, 86 | Madrid | 28034 | Spain | (91) 555 94 44 | (91) 555 55 93 | |
| ROMEY | Romero y tomillo | Alejandra Camino | Accounting Manager | Gran Va, 1 | Madrid | 28001 | Spain | (91) 745 6200 | (91) 745 6210 | |
| GODOS | Godos Cocina Tpica | Jos Pedro Freyre | Sales Manager | C/ Romero, 33 | Sevilla | 41101 | Spain | (95) 555 82 82 | ||
| FOLKO | Folk och f HB | Maria Larsson | Owner | kergatan 24 | Brcke | S-844 67 | Sweden | 0695-34 67 21 | ||
| BERGS | Berglunds snabbkp | Christina Berglund | Order Administrator | Berguvsvgen 8 | Lule | S-958 22 | Sweden | 0921-12 34 65 | 0921-12 34 67 | |
| CHOPS | Chop-suey Chinese | Yang Wang | Owner | Hauptstr. 29 | Bern | 3012 | Switzerland | 0452-076545 | ||
| RICSU | Richter Supermarkt | Michael Holz | Sales Manager | Grenzacherweg 237 | Genve | 1203 | Switzerland | 0897-034214 | ||
| ISLAT | Island Trading | Helen Bennett | Marketing Manager | Garden House Crowther Way | Cowes | Isle of Wight | PO31 7PJ | UK | (198) 555-8888 | |
| AROUT | Around the Horn | Thomas Hardy | Sales Representative | 120 Hanover Sq. | London | WA1 1DP | UK | (171) 555-7788 | (171) 555-6750 | |
| BSBEV | B's Beverages | Victoria Ashworth | Sales Representative | Fauntleroy Circus | London | EC2 5NT | UK | (171) 555-1212 | ||
| CONSH | Consolidated Holdings | Elizabeth Brown | Sales Representative | Berkeley Gardens 12 Brewery | London | WX1 6LT | UK | (171) 555-2282 | (171) 555-9199 | |
| EASTC | Eastern Connection | Ann Devon | Sales Agent | 35 King George | London | WX3 6FW | UK | (171) 555-0297 | (171) 555-3373 | |
| NORTS | North/South | Simon Crowther | Sales Associate | South House 300 Queensbridge | London | SW7 1RZ | UK | (171) 555-7733 | (171) 555-2530 | |
| SEVES | Seven Seas Imports | Hari Kumar | Sales Manager | 90 Wadhurst Rd. | London | OX15 4NB | UK | (171) 555-1717 | (171) 555-5646 | |
| RATTC | Rattlesnake Canyon Grocery | Paula Wilson | Assistant Sales Representative | 2817 Milton Dr. | Albuquerque | NM | 87110 | USA | (505) 555-5939 | (505) 555-3620 |
| OLDWO | Old World Delicatessen | Rene Phillips | Sales Representative | 2743 Bering St. | Anchorage | AK | 99508 | USA | (907) 555-7584 | (907) 555-2880 |
| SAVEA | Save-a-lot Markets | Jose Pavarotti | Sales Representative | 187 Suffolk Ln. | Boise | ID | 83720 | USA | (208) 555-8097 | |
| THECR | The Cracker Box | Liu Wong | Marketing Assistant | 55 Grizzly Peak Rd. | Butte | MT | 59801 | USA | (406) 555-5834 | (406) 555-8083 |
| HUNGC | Hungry Coyote Import Store | Yoshi Latimer | Sales Representative | City Center Plaza 516 Main St. | Elgin | OR | 97827 | USA | (503) 555-6874 | (503) 555-2376 |
| GREAL | Great Lakes Food Market | Howard Snyder | Marketing Manager | 2732 Baker Blvd. | Eugene | OR | 97403 | USA | (503) 555-7555 | |
| TRAIH | Trail's Head Gourmet Provisioners | Helvetius Nagy | Sales Associate | 722 DaVinci Blvd. | Kirkland | WA | 98034 | USA | (206) 555-8257 | (206) 555-2174 |
| SPLIR | Split Rail Beer & Ale | Art Braunschweiger | Sales Manager | P.O. Box 555 | Lander | WY | 82520 | USA | (307) 555-4680 | (307) 555-6525 |
| LONEP | Lonesome Pine Restaurant | Fran Wilson | Sales Manager | 89 Chiaroscuro Rd. | Portland | OR | 97219 | USA | (503) 555-9573 | (503) 555-9646 |
| THEBI | The Big Cheese | Liz Nixon | Marketing Manager | 89 Jefferson Way Suite 2 | Portland | OR | 97201 | USA | (503) 555-3612 | |
| LETSS | Let's Stop N Shop | Jaime Yorres | Owner | 87 Polk St. Suite 5 | San Francisco | CA | 94117 | USA | (415) 555-5938 | |
| WHITC | White Clover Markets | Karl Jablonski | Owner | 305 - 14th Ave. S. Suite 3B | Seattle | WA | 98128 | USA | (206) 555-4112 | (206) 555-4115 |
| LAZYK | Lazy K Kountry Store | John Steel | Marketing Manager | 12 Orchestra Terrace | Walla Walla | WA | 99362 | USA | (509) 555-7969 | (509) 555-6221 |
| LILAS | LILA-Supermercado | Carlos Gonzlez | Accounting Manager | Carrera 52 con Ave. Bolvar #65-98 Llano Largo | Barquisimeto | Lara | 3508 | Venezuela | (9) 331-6954 | (9) 331-7256 |
| GROSR | GROSELLA-Restaurante | Manuel Pereira | Owner | 5 Ave. Los Palos Grandes | Caracas | DF | 1081 | Venezuela | (2) 283-2951 | (2) 283-3397 |
| 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 |
| HILAA | HILARION-Abastos | Carlos Hernndez | Sales Representative | Carrera 22 con Ave. Carlos Soublette #8-35 | San Cristbal | Tchira | 5022 | Venezuela | (5) 555-1340 | (5) 555-1948 |
Vilka produkter är inte beställda (UnitsOnOrder=0) men har unitsInStock mindre än ReorderLevel.
1 rader
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
|---|---|---|---|---|---|---|---|---|---|
| 30 | Nord-Ost Matjeshering | 13 | 8 | 10 - 200 g glasses | 25.8900 | 10 | 0 | 15 | 0 |
Vilka av de anställda har tilltalet Mr. (TitleOfCourtesy) och jobbar i UK?
3 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 |
Vilka av de anställda har tilltalet Mr. (TitleOfCourtesy) och jobbar i UK eller har tilltalet Ms. Och jobbar i USA
6 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1963-08-30 00:00:00 | 1992-04-01 00:00:00 | 722 Moss Bay Blvd. | Kirkland | WA | 98033 | USA | (206) 555-3412 | 3355 | img | img | 2 | http://accweb/emmployees/leverling.bmp | 3119.15 |
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 | |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1958-01-09 00:00:00 | 1994-03-05 00:00:00 | 4726 - 11th Ave. N.E. | Seattle | WA | 98105 | USA | (206) 555-1189 | 2344 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2100.5 |
Vilka av de anställda som jobbar i UK har tilltalet Dr. eller Mr.
3 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 |
Vilka av de anställda (employees) är manager?
1 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 |
Visa alla anställda vars efternamn slutar med ett “o”.
1 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
Vem av de anställda är manager eller arbetar med sales?
9 rader
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate | Address | City | Region | PostalCode | Country | HomePhone | Extension | Photo | Notes | ReportsTo | PhotoPath | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1948-12-08 00:00:00 | 1992-05-01 00:00:00 | 507 - 20th Ave. E.Apt. 2A | Seattle | WA | 98122 | USA | (206) 555-9857 | 5467 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2954.55 |
| 2 | Fuller | Andrew | Vice President, Sales | Dr. | 1952-02-19 00:00:00 | 1992-08-14 00:00:00 | 908 W. Capital Way | Tacoma | WA | 98401 | USA | (206) 555-9482 | 3457 | img | img | http://accweb/emmployees/fuller.bmp | 2254.49 | |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1963-08-30 00:00:00 | 1992-04-01 00:00:00 | 722 Moss Bay Blvd. | Kirkland | WA | 98033 | USA | (206) 555-3412 | 3355 | img | img | 2 | http://accweb/emmployees/leverling.bmp | 3119.15 |
| 4 | Peacock | Margaret | Sales Representative | Mrs. | 1937-09-19 00:00:00 | 1993-05-03 00:00:00 | 4110 Old Redmond Rd. | Redmond | WA | 98052 | USA | (206) 555-8122 | 5176 | img | img | 2 | http://accweb/emmployees/peacock.bmp | 1861.08 |
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1955-03-04 00:00:00 | 1993-10-17 00:00:00 | 14 Garrett Hill | London | SW1 8JR | UK | (71) 555-4848 | 3453 | img | img | 2 | http://accweb/emmployees/buchanan.bmp | 1744.21 | |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1963-07-02 00:00:00 | 1993-10-17 00:00:00 | Coventry House Miner Rd. | London | EC2 7JR | UK | (71) 555-7773 | 428 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2004.07 | |
| 7 | King | Robert | Sales Representative | Mr. | 1960-05-29 00:00:00 | 1994-01-02 00:00:00 | Edgeham Hollow Winchester Way | London | RG1 9SP | UK | (71) 555-5598 | 465 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 1991.55 | |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1958-01-09 00:00:00 | 1994-03-05 00:00:00 | 4726 - 11th Ave. N.E. | Seattle | WA | 98105 | USA | (206) 555-1189 | 2344 | img | img | 2 | http://accweb/emmployees/davolio.bmp | 2100.5 |
| 9 | Dodsworth | Anne | Sales Representative | Ms. | 1966-01-27 00:00:00 | 1994-11-15 00:00:00 | 7 Houndstooth Rd. | London | WG2 7LT | UK | (71) 555-4444 | 452 | img | img | 5 | http://accweb/emmployees/davolio.bmp | 2333.33 |
Visa alla produkter så att namnet och lagervärdet visas (UnitsInStock*UnitPrice)
77 rader
| productname | Lagervärde |
|---|---|
| Chai | 702.0000 |
| Chang | 323.0000 |
| Aniseed Syrup | 130.0000 |
| Chef Anton's Cajun Seasoning | 1166.0000 |
| Chef Anton's Gumbo Mix | 0.0000 |
| Grandma's Boysenberry Spread | 3000.0000 |
| Uncle Bob's Organic Dried Pears | 450.0000 |
| Northwoods Cranberry Sauce | 240.0000 |
| Mishi Kobe Niku | 2813.0000 |
| Ikura | 961.0000 |
| Queso Cabrales | 462.0000 |
| Queso Manchego La Pastora | 3268.0000 |
| Konbu | 144.0000 |
| Tofu | 813.7500 |
| Genen Shouyu | 604.5000 |
| Pavlova | 506.0500 |
| Alice Mutton | 0.0000 |
| Carnarvon Tigers | 2625.0000 |
| Teatime Chocolate Biscuits | 230.0000 |
| Sir Rodney's Marmalade | 3240.0000 |
| Sir Rodney's Scones | 30.0000 |
| Gustaf's Knckebrd | 2184.0000 |
| Tunnbrd | 549.0000 |
| Guaran Fantstica | 90.0000 |
| NuNuCa Nu-Nougat-Creme | 1064.0000 |
| Gumbr Gummibrchen | 468.4500 |
| Schoggi Schokolade | 2151.1000 |
| Rssle Sauerkraut | 1185.6000 |
| Thringer Rostbratwurst | 0.0000 |
| Nord-Ost Matjeshering | 258.9000 |
| Gorgonzola Telino | 0.0000 |
| Mascarpone Fabioli | 288.0000 |
| Geitost | 280.0000 |
| Sasquatch Ale | 1554.0000 |
| Steeleye Stout | 360.0000 |
| Inlagd Sill | 2128.0000 |
| Gravad lax | 286.0000 |
| Cte de Blaye | 4479.5000 |
| Chartreuse verte | 1242.0000 |
| Boston Crab Meat | 2263.2000 |
| Jack's New England Clam Chowder | 820.2500 |
| Singaporean Hokkien Fried Mee | 364.0000 |
| Ipoh Coffee | 782.0000 |
| Gula Malacca | 525.1500 |
| Rogede sild | 47.5000 |
| Spegesild | 1140.0000 |
| Zaanse koeken | 342.0000 |
| Chocolade | 191.2500 |
| Maxilaku | 200.0000 |
| Valkoinen suklaa | 1056.2500 |
| Manjimup Dried Apples | 1060.0000 |
| Filo Mix | 266.0000 |
| Perth Pasties | 0.0000 |
| Tourtire | 156.4500 |
| Pt chinois | 2760.0000 |
| Gnocchi di nonna Alice | 798.0000 |
| Ravioli Angelo | 702.0000 |
| Escargots de Bourgogne | 821.5000 |
| Raclette Courdavault | 4345.0000 |
| Camembert Pierrot | 646.0000 |
| Sirop d'rable | 3220.5000 |
| Tarte au sucre | 838.1000 |
| Vegie-spread | 1053.6000 |
| Wimmers gute Semmelkndel | 731.5000 |
| Louisiana Fiery Hot Pepper Sauce | 1599.8000 |
| Louisiana Hot Spiced Okra | 68.0000 |
| Laughing Lumberjack Lager | 728.0000 |
| Scottish Longbreads | 75.0000 |
| Gudbrandsdalsost | 936.0000 |
| Outback Lager | 225.0000 |
| Flotemysost | 559.0000 |
| Mozzarella di Giovanni | 487.2000 |
| Rd Kaviar | 1515.0000 |
| Longlife Tofu | 40.0000 |
| Rhnbru Klosterbier | 968.7500 |
| Lakkalikri | 1026.0000 |
| Original Frankfurter grne Soe | 416.0000 |
Visa alla kunder med namnet och kundid i samma fält så att namnet visas först och sedan kundid inom parentes, fältet skall kallas Kund
93 rader
| Kund |
|---|
| Alfreds Futterkiste (ALFKI) |
| Ana Trujillo Emparedados y helados (ANATR) |
| Antonio Moreno Taquera (ANTON) |
| Around the Horn (AROUT) |
| B's Beverages (BSBEV) |
| Berglunds snabbkp (BERGS) |
| Blauer See Delikatessen (BLAUS) |
| Blido Comidas preparadas (BOLID) |
| Blondesddsl pre et fils (BLONP) |
| Bon app' (BONAP) |
| Bottom-Dollar Markets (BOTTM) |
| Cactus Comidas para llevar (CACTU) |
| Centro comercial Moctezuma (CENTC) |
| Chop-suey Chinese (CHOPS) |
| Comrcio Mineiro (COMMI) |
| Consolidated Holdings (CONSH) |
| Die Wandernde Kuh (WANDK) |
| Drachenblut Delikatessen (DRACD) |
| Du monde entier (DUMON) |
| Eastern Connection (EASTC) |
| Ernst Handel (ERNSH) |
| Familia Arquibaldo (FAMIA) |
| FISSA Fabrica Inter. Salchichas S.A. (FISSA) |
| Folies gourmandes (FOLIG) |
| Folk och f HB (FOLKO) |
| France restauration (FRANR) |
| Franchi S.p.A. (FRANS) |
| Frankenversand (FRANK) |
| Furia Bacalhau e Frutos do Mar (FURIB) |
| Galera del gastrnomo (GALED) |
| Godos Cocina Tpica (GODOS) |
| Gourmet Lanchonetes (GOURL) |
| Great Lakes Food Market (GREAL) |
| GROSELLA-Restaurante (GROSR) |
| Hanari Carnes (HANAR) |
| HILARION-Abastos (HILAA) |
| Hungry Coyote Import Store (HUNGC) |
| Hungry Owl All-Night Grocers (HUNGO) |
| Island Trading (ISLAT) |
| IT (Val2 ) |
| IT (VALON) |
| Kniglich Essen (KOENE) |
| La corne d'abondance (LACOR) |
| La maison d'Asie (LAMAI) |
| Laughing Bacchus Wine Cellars (LAUGB) |
| Lazy K Kountry Store (LAZYK) |
| Lehmanns Marktstand (LEHMS) |
| Let's Stop N Shop (LETSS) |
| LILA-Supermercado (LILAS) |
| LINO-Delicateses (LINOD) |
| Lonesome Pine Restaurant (LONEP) |
| Magazzini Alimentari Riuniti (MAGAA) |
| Maison Dewey (MAISD) |
| Morgenstern Gesundkost (MORGK) |
| Mre Paillarde (MEREP) |
| North/South (NORTS) |
| Ocano Atlntico Ltda. (OCEAN) |
| Old World Delicatessen (OLDWO) |
| Ottilies Kseladen (OTTIK) |
| Paris spcialits (PARIS) |
| Pericles Comidas clsicas (PERIC) |
| Piccolo und mehr (PICCO) |
| Princesa Isabel Vinhos (PRINI) |
| Que Delcia (QUEDE) |
| Queen Cozinha (QUEEN) |
| QUICK-Stop (QUICK) |
| Rancho grande (RANCH) |
| Rattlesnake Canyon Grocery (RATTC) |
| Reggiani Caseifici (REGGC) |
| Ricardo Adocicados (RICAR) |
| Richter Supermarkt (RICSU) |
| Romero y tomillo (ROMEY) |
| Sant Gourmet (SANTG) |
| Save-a-lot Markets (SAVEA) |
| Seven Seas Imports (SEVES) |
| Simons bistro (SIMOB) |
| Spcialits du monde (SPECD) |
| Split Rail Beer & Ale (SPLIR) |
| Suprmes dlices (SUPRD) |
| The Big Cheese (THEBI) |
| The Cracker Box (THECR) |
| Toms Spezialitten (TOMSP) |
| Tortuga Restaurante (TORTU) |
| Tradio Hipermercados (TRADH) |
| Trail's Head Gourmet Provisioners (TRAIH) |
| Vaffeljernet (VAFFE) |
| Victuailles en stock (VICTE) |
| Vins et alcools Chevalier (VINET) |
| Wartian Herkku (WARTH) |
| Wellington Importadora (WELLI) |
| White Clover Markets (WHITC) |
| Wilman Kala (WILMK) |
| Wolski Zajazd (WOLZA) |
Hur många kunder finns det totalt
1 rader
| Count(*) |
|---|
| 93 |
Hur många kunder finns det i de olika länderna
22 rader
| country | Count(*) |
|---|---|
| 2 | |
| Argentina | 3 |
| Austria | 2 |
| Belgium | 2 |
| Brazil | 9 |
| Canada | 3 |
| Denmark | 2 |
| Finland | 2 |
| France | 11 |
| Germany | 11 |
| Ireland | 1 |
| Italy | 3 |
| Mexico | 5 |
| Norway | 1 |
| Poland | 1 |
| Portugal | 2 |
| Spain | 5 |
| Sweden | 2 |
| Switzerland | 2 |
| UK | 7 |
| USA | 13 |
| Venezuela | 4 |
Använd inner join för att visa alla producter och deras CategoryName.
77 rader
| Productname | CategoryName |
|---|---|
| Chai | Beverages |
| Chang | Beverages |
| Guaran Fantstica | Beverages |
| Sasquatch Ale | Beverages |
| Steeleye Stout | Beverages |
| Cte de Blaye | Beverages |
| Chartreuse verte | Beverages |
| Ipoh Coffee | Beverages |
| Laughing Lumberjack Lager | Beverages |
| Outback Lager | Beverages |
| Rhnbru Klosterbier | Beverages |
| Lakkalikri | Beverages |
| Aniseed Syrup | Condiments |
| Chef Anton's Cajun Seasoning | Condiments |
| Chef Anton's Gumbo Mix | Condiments |
| Grandma's Boysenberry Spread | Condiments |
| Northwoods Cranberry Sauce | Condiments |
| Genen Shouyu | Condiments |
| Gula Malacca | Condiments |
| Sirop d'rable | Condiments |
| Vegie-spread | Condiments |
| Louisiana Fiery Hot Pepper Sauce | Condiments |
| Louisiana Hot Spiced Okra | Condiments |
| Original Frankfurter grne Soe | Condiments |
| Pavlova | Confections |
| Teatime Chocolate Biscuits | Confections |
| Sir Rodney's Marmalade | Confections |
| Sir Rodney's Scones | Confections |
| NuNuCa Nu-Nougat-Creme | Confections |
| Gumbr Gummibrchen | Confections |
| Schoggi Schokolade | Confections |
| Zaanse koeken | Confections |
| Chocolade | Confections |
| Maxilaku | Confections |
| Valkoinen suklaa | Confections |
| Tarte au sucre | Confections |
| Scottish Longbreads | Confections |
| Queso Cabrales | Dairy Products |
| Queso Manchego La Pastora | Dairy Products |
| Gorgonzola Telino | Dairy Products |
| Mascarpone Fabioli | Dairy Products |
| Geitost | Dairy Products |
| Raclette Courdavault | Dairy Products |
| Camembert Pierrot | Dairy Products |
| Gudbrandsdalsost | Dairy Products |
| Flotemysost | Dairy Products |
| Mozzarella di Giovanni | Dairy Products |
| Gustaf's Knckebrd | Grains/Cereals |
| Tunnbrd | Grains/Cereals |
| Singaporean Hokkien Fried Mee | Grains/Cereals |
| Filo Mix | Grains/Cereals |
| Gnocchi di nonna Alice | Grains/Cereals |
| Ravioli Angelo | Grains/Cereals |
| Wimmers gute Semmelkndel | Grains/Cereals |
| Mishi Kobe Niku | Meat/Poultry |
| Alice Mutton | Meat/Poultry |
| Thringer Rostbratwurst | Meat/Poultry |
| Perth Pasties | Meat/Poultry |
| Tourtire | Meat/Poultry |
| Pt chinois | Meat/Poultry |
| Uncle Bob's Organic Dried Pears | Produce |
| Tofu | Produce |
| Rssle Sauerkraut | Produce |
| Manjimup Dried Apples | Produce |
| Longlife Tofu | Produce |
| Ikura | Seafood |
| Konbu | Seafood |
| Carnarvon Tigers | Seafood |
| Nord-Ost Matjeshering | Seafood |
| Inlagd Sill | Seafood |
| Gravad lax | Seafood |
| Boston Crab Meat | Seafood |
| Jack's New England Clam Chowder | Seafood |
| Rogede sild | Seafood |
| Spegesild | Seafood |
| Escargots de Bourgogne | Seafood |
| Rd Kaviar | Seafood |
Vilka produkter levereras av “New England Seafood Cannery”?
2 rader
| productname | CompanyName |
|---|---|
| Boston Crab Meat | New England Seafood Cannery |
| Jack's New England Clam Chowder | New England Seafood Cannery |
Vilka levererar lax?
1 rader
| Companyname |
|---|
| Svensk Sjfda AB |