gurung_Exp19_Access_Ch6_Cap_Northwind.accdb
| CategoryID | CategoryName | Description | Picture | mSysRowId |
| 1 | Beverages | Soft drinks, coffees, teas, beers, and ales |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 2 | Condiments | Sweet and savory sauces, relishes, spreads, and seasonings |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 3 | Confections | Desserts, candies, and sweet breads |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 4 | Dairy Products | Cheeses |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 5 | Grains/Cereals | Breads, crackers, pasta, and cereal |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 6 | Meat/Poultry | Prepared meats |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 7 | Produce | Dried fruit and bean curd |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| 8 | Seafood | Seaweed and fish |
| U7NeqrK9FkShfcjzJ1FtRrUrZDvkgZxwdTmzmyh6TEc=-~gUQMqra4XRi1sH8FgALf7A== |
| CustomerID | CompanyName | ContactName | Address | City | PostalCode | Country | Phone |
| BONAP | Bon app' | Laurence Lebihan | 12, rue des Bouchers | Marseille | 13008 | France | 91.24.45.40 |
| CHOPS | Chop-suey Chinese | Yang Wang | Hauptstr. 29 | Bern | 3012 | Switzerland | 0452-076545 |
| KOENE | Königlich Essen | Philip Cramer | Maubelstr. 90 | Brandenburg | 14776 | Germany | 0555-09876 |
| LILAS | LILA-Supermercado | Carlos González | Carrera 52 con Ave. Bolívar #65-98 Llano Largo | Barquisimeto | 3508 | Venezuela | (9) 331-6954 |
| RICSU | Richter Supermarkt | Michael Holz | Grenzacherweg 237 | Genève | 1203 | Switzerland | 0897-034214 |
| SAVEA | Save-a-lot Markets | Jose Pavarotti | 187 Suffolk Ln. | Boise | 83720 | USA | (208) 555-8097 |
| SPLIR | Split Rail Beer & Ale | Art Braunschweiger | P.O. Box 555 | Lander | 82520 | USA | (307) 555-4680 |
| WHITC | White Clover Markets | Karl Jablonski | 305 - 14th Ave. S.
Suite 3B | Seattle | 98128 | USA | (206) 555-4112 |
| WILMK | Wilman Kala | Matti Karttunen | Keskuskatu 45 | Helsinki | 21240 | Finland | 90-224 8858 |
| EmployeeID | LastName | FirstName | Title | HireDate | Address | City | PostalCode | mSysRowId |
| 1 | Davolio | Nancy | Sales Representative | 5/1/12 | 507 - 20th Ave. E.
Apt. 2A | Seattle | 98122 | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 2 | Fuller | Andrew | Vice President, Sales | 8/14/12 | 908 W. Capital Way | Tacoma | 98401 | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 3 | Lorah | Ron | Sales Representative | 4/1/09 | 722 Moss Bay Blvd. | Kirkland | 98033 | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 4 | Peacock | Margaret | Sales Representative | 5/3/08 | 4110 Old Redmond Rd. | Redmond | 98052 | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 5 | Buchanan | Steven | Sales Manager | 10/17/05 | 14 Garrett Hill | London | SW1 8JR | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 6 | Suyama | Michael | Sales Representative | 10/17/06 | Coventry House
Miner Rd. | London | EC2 7JR | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 7 | King | Robert | Sales Representative | 1/2/05 | Edgeham Hollow
Winchester Way | London | RG1 9SP | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 8 | Callahan | Laura | Inside Sales Coordinator | 3/5/11 | 4726 - 11th Ave. N.E. | Seattle | 98105 | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| 9 | Dodsworth | Anne | Sales Representative | 11/15/10 | 7 Houndstooth Rd. | London | WG2 7LT | qUHwlGqe+lJMauy85HeUeVAhTa9N8P7/m8kr1sWpbEI=-~/hkJMFV/jrN2O0wg1pGCTA== |
| ID | mSysRowId |
| 1 | hUwoUI2vRZkcnXVOLBW5PpCGvRx804vHn2miEc5idIE=-~LuyNwBz1ozsG8x5rZZRD8A== |
| OrderID | ProductID | Quantity | Discount | mSysRowId |
| 10248 | 11 | 12 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10248 | 42 | 10 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10248 | 72 | 5 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10329 | 19 | 10 | 0.05 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10329 | 30 | 8 | 0.05 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10329 | 38 | 20 | 0.05 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10329 | 56 | 12 | 0.05 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10330 | 26 | 50 | 0.15 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10330 | 72 | 25 | 0.15 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10331 | 54 | 15 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10607 | 7 | 45 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10607 | 17 | 100 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10607 | 33 | 14 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10607 | 40 | 42 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 10607 | 72 | 12 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11028 | 55 | 35 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11028 | 59 | 24 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11029 | 56 | 20 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11029 | 63 | 12 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11032 | 36 | 35 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11032 | 38 | 25 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11032 | 59 | 30 | 0.0 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11033 | 53 | 70 | 0.1 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| 11033 | 69 | 36 | 0.1 | 9iwvprJBKUjmgwHrkwtclX4Q9O7WXMVwZVQJsEAwLvc=-~bB1SsceBNArjRJTqZ4ElsA== |
| OrderID | CustomerID | EmployeeID | ShippedDate | ShipVia | Freight | ShipCountry | mSysRowId |
| 10248 | WILMK | 5 | 5/25/20 | 3 | ¤ 44.84 | Belgium | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 10329 | SPLIR | 4 | 9/1/20 | 1 | ¤ 40.42 | Germany | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 10330 | LILAS | 3 | 9/6/20 | 2 | ¤ 25.19 | USA | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 10331 | BONAP | 9 | 8/30/20 | 2 | ¤ 3.04 | UK | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 10607 | SAVEA | 5 | 6/2/20 | 2 | ¤ 36.71 | Germany | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 11028 | KOENE | 2 | 2/27/20 | 3 | ¤ 146.06 | Austria | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 11029 | CHOPS | 4 | 3/4/20 | 3 | ¤ 12.76 | Brazil | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 11032 | WHITC | 2 | 2/28/20 | 3 | ¤ 3.67 | Sweden | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| 11033 | RICSU | 7 | 2/28/20 | 1 | ¤ 55.28 | France | 5yXgx2iZyyH8bS+hFvdkNiblmb1IQK5cAcHOG2s+hTM=-~SdQRlLMlWZ0/E7BY2gpQBA== |
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | ProductCost | Discontinued |
| 7 | Uncle Bob's Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | ¤ 33.71 | ¤ 22.50 | false |
| 11 | Queso Cabrales | 5 | 4 | 1 kg pkg. | ¤ 23.60 | ¤ 16.00 | false |
| 17 | Alice Mutton | 7 | 6 | 20 - 1 kg tins | ¤ 43.82 | ¤ 20.70 | true |
| 19 | Teatime Chocolate Biscuits | 8 | 3 | 10 boxes x 12 pieces | ¤ 10.34 | ¤ 4.50 | false |
| 26 | Gumbär Gummibärchen | 11 | 3 | 100 - 250 g bags | ¤ 35.09 | ¤ 22.80 | false |
| 30 | Nord-Ost Matjeshering | 13 | 8 | 10 - 200 g glasses | ¤ 29.09 | ¤ 12.20 | false |
| 33 | Geitost | 15 | 4 | 500 g | ¤ 2.25 | ¤ 2.01 | false |
| 36 | Inlagd Sill | 17 | 8 | 24 - 250 g jars | ¤ 21.35 | ¤ 18.51 | false |
| 38 | Côte de Blaye | 18 | 1 | 12 - 75 cl bottles | ¤ 295.51 | ¤ 263.01 | false |
| 40 | Boston Crab Meat | 19 | 8 | 24 - 4 oz tins | ¤ 20.67 | ¤ 17.91 | false |
| 42 | Singaporean Hokkien Fried Mee | 20 | 5 | 32 - 1 kg pkgs. | ¤ 15.73 | ¤ 13.51 | true |
| 53 | Perth Pasties | 24 | 6 | 48 pieces | ¤ 36.85 | ¤ 32.31 | true |
| 54 | Tourtière | 25 | 6 | 16 pies | ¤ 8.37 | ¤ 6.96 | false |
| 55 | Pâté chinois | 25 | 6 | 24 boxes x 2 pies | ¤ 26.97 | ¤ 23.51 | false |
| 56 | Gnocchi di nonna Alice | 26 | 5 | 24 - 250 g pkgs. | ¤ 42.70 | ¤ 37.51 | false |
| 59 | Raclette Courdavault | 28 | 4 | 5 kg pkg. | ¤ 61.80 | ¤ 54.51 | false |
| 63 | Vegie-spread | 7 | 2 | 15 - 625 g jars | ¤ 49.33 | ¤ 43.41 | false |
| 68 | Scottish Longbreads | 8 | 3 | 10 boxes x 8 pieces | ¤ 14.04 | ¤ 12.01 | false |
| 69 | Gudbrandsdalsost | 15 | 4 | 10 kg pkg. | ¤ 40.45 | ¤ 35.51 | false |
| 72 | Mozzarella di Giovanni | 14 | 4 | 24 - 200 g pkgs. | ¤ 38.20 | ¤ 34.31 | false |
| ShipperID | CompanyName | Phone | mSysRowId |
| 1 | Speedy Express | (503) 555-9831 | M9/3awGCrpYtcT3cqnG4HMk8XDW1fNOcjYmmrfVZ7PQ=-~6oP5HBbRrUR9yzmVObqzsg== |
| 2 | United Package | (503) 555-3199 | M9/3awGCrpYtcT3cqnG4HMk8XDW1fNOcjYmmrfVZ7PQ=-~6oP5HBbRrUR9yzmVObqzsg== |
| 3 | Federal Shipping | (503) 555-9931 | M9/3awGCrpYtcT3cqnG4HMk8XDW1fNOcjYmmrfVZ7PQ=-~6oP5HBbRrUR9yzmVObqzsg== |
| SupplierID | CompanyName | ContactName | Address | City | PostalCode | Country | Phone | mSysRowId |
| 3 | Grandma Kelly's Homestead | Regina Murphy | 707 Oxford Rd. | Ann Arbor | 48104 | USA | (313) 555-5735 |
|
| 5 | Cooperativa de Quesos 'Las Cabras' | Antonio del Valle Saavedra | Calle del Rosal 4 | Oviedo | 33007 | Spain | (98) 598 76 54 |
|
| 7 | Pavlova, Ltd. | Ian Devling | 74 Rose St.
Moonie Ponds | Melbourne | 3058 | Australia | (03) 444-2343 |
|
| 8 | Specialty Biscuits, Ltd. | Peter Wilson | 29 King's Way | Manchester | M14 GSD | UK | (161) 555-4448 |
|
| 11 | Heli Süßwaren GmbH & Co. KG | Petra Winkler | Tiergartenstraße 5 | Berlin | 10785 | Germany | (010) 9984510 |
|
| 13 | Nord-Ost-Fisch Handelsgesellschaft mbH | Sven Petersen | Frahmredder 112a | Cuxhaven | 27478 | Germany | (04721) 8713 |
|
| 14 | Formaggi Fortini s.r.l. | Elio Rossi | Viale Dante, 75 | Ravenna | 48100 | Italy | (0544) 60323 |
|
| 15 | Norske Meierier | Beate Vileid | Hatlevegen 5 | Sandvika | 1320 | Norway | (0)2-953010 |
|
| 17 | Svensk Sjöföda AB | Michael Björn | Brovallavägen 231 | Stockholm | S-123 45 | Sweden | 08-123 45 67 |
|
| 18 | Aux joyeux ecclésiastiques | Guylène Nodier | 203, Rue des Francs-Bourgeois | Paris | 75004 | France | (1) 03.83.00.68 |
|
| 19 | New England Seafood Cannery | Robb Merchant | Order Processing Dept.
2100 Paul Revere Blvd. | Boston | 02134 | USA | (617) 555-3267 |
|
| 20 | Leka Trading | Chandra Leka | 471 Serangoon Loop, Suite #402 | Singapore | 0512 | Singapore | 555-8787 |
|
| 24 | G'day, Mate | Wendy Mackenzie | 170 Prince Edward Parade
Hunter's Hill | Sydney | 2042 | Australia | (02) 555-5914 |
|
| 25 | Ma Maison | Jean-Guy Lauzon | 2960 Rue St. Laurent | Montréal | H1J 1C3 | Canada | (514) 555-9022 |
|
| 26 | Pasta Buttini s.r.l. | Giovanni Giudici | Via dei Gelsomini, 153 | Salerno | 84100 | Italy | (089) 6547665 |
|
| 28 | Gai pâturage | Eliane Noz | Bat. B
3, rue des Alpes | Annecy | 74000 | France | 38.76.98.06 |
|
SELECT [Order Details].Quantity, [Order Details].Discount, Products.UnitPrice, Products.ProductCost, Categories.CategoryName, Orders.ShippedDate, Orders.ShipCountry, [UnitPrice]*(1-[Discount])*[Quantity]-[ProductCost]*[Quantity] AS Profit
FROM (Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) INNER JOIN ((Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID;
suman13
