Blake_Exp19_Access_Ch6_Cap_Northwind.accdb
| CategoryID |
CategoryName |
Description |
Picture |
mSysRowId |
| 1 |
Beverages |
Soft drinks, coffees, teas, beers, and ales |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 2 |
Condiments |
Sweet and savory sauces, relishes, spreads, and seasonings |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 3 |
Confections |
Desserts, candies, and sweet breads |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 4 |
Dairy Products |
Cheeses |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 5 |
Grains/Cereals |
Breads, crackers, pasta, and cereal |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 6 |
Meat/Poultry |
Prepared meats |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 7 |
Produce |
Dried fruit and bean curd |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 8 |
Seafood |
Seaweed and fish |
|
w54GwnFg/g9EAheXDvSNY5dSF9m56atdpBp1/rmrPQo=-~56qTW2GPaA7rDvgMGwxBsw== |
| 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 |
2012-05-01 |
507 - 20th Ave. E.
Apt. 2A |
Seattle |
98122 |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 2 |
Fuller |
Andrew |
Vice President, Sales |
2012-08-14 |
908 W. Capital Way |
Tacoma |
98401 |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 3 |
Lorah |
Ron |
Sales Representative |
2009-04-01 |
722 Moss Bay Blvd. |
Kirkland |
98033 |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 4 |
Peacock |
Margaret |
Sales Representative |
2008-05-03 |
4110 Old Redmond Rd. |
Redmond |
98052 |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 5 |
Buchanan |
Steven |
Sales Manager |
2005-10-17 |
14 Garrett Hill |
London |
SW1 8JR |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 6 |
Suyama |
Michael |
Sales Representative |
2006-10-17 |
Coventry House
Miner Rd. |
London |
EC2 7JR |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 7 |
King |
Robert |
Sales Representative |
2005-01-02 |
Edgeham Hollow
Winchester Way |
London |
RG1 9SP |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 8 |
Callahan |
Laura |
Inside Sales Coordinator |
2011-03-05 |
4726 - 11th Ave. N.E. |
Seattle |
98105 |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| 9 |
Dodsworth |
Anne |
Sales Representative |
2010-11-15 |
7 Houndstooth Rd. |
London |
WG2 7LT |
H3BjnUTEYK73NWrYFWaPMggX/2QDzHsCN2Vl3XQkoAY=-~gn+c/8T/Oj0Yigt7nC7Czg== |
| ID |
mSysRowId |
| 1 |
6lIk0sSYjTR8/gH9EbX6AMUGaxZB1ufwmFYQtE0UtAg=-~78HY6CikV16gNNGVgqzsDQ== |
| OrderID |
ProductID |
Quantity |
Discount |
mSysRowId |
| 10248 |
11 |
12 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10248 |
42 |
10 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10248 |
72 |
5 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10329 |
19 |
10 |
0.05 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10329 |
30 |
8 |
0.05 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10329 |
38 |
20 |
0.05 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10329 |
56 |
12 |
0.05 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10330 |
26 |
50 |
0.15 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10330 |
72 |
25 |
0.15 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10331 |
54 |
15 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10607 |
7 |
45 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10607 |
17 |
100 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10607 |
33 |
14 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10607 |
40 |
42 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 10607 |
72 |
12 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11028 |
55 |
35 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11028 |
59 |
24 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11029 |
56 |
20 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11029 |
63 |
12 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11032 |
36 |
35 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11032 |
38 |
25 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11032 |
59 |
30 |
0.0 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11033 |
53 |
70 |
0.1 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| 11033 |
69 |
36 |
0.1 |
RruBnuP+azgVH0I4+JuwQB5KTkILQ20Gs7pv5a3nXLs=-~zgSGDrDT0wzIo9FbVKXWKw== |
| OrderID |
CustomerID |
EmployeeID |
ShippedDate |
ShipVia |
Freight |
ShipCountry |
mSysRowId |
| 10248 |
WILMK |
5 |
2020-05-25 |
3 |
¤ 44.84 |
Belgium |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 10329 |
SPLIR |
4 |
2020-09-01 |
1 |
¤ 40.42 |
Germany |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 10330 |
LILAS |
3 |
2020-09-06 |
2 |
¤ 25.19 |
USA |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 10331 |
BONAP |
9 |
2020-08-30 |
2 |
¤ 3.04 |
UK |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 10607 |
SAVEA |
5 |
2020-06-02 |
2 |
¤ 36.71 |
Germany |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 11028 |
KOENE |
2 |
2020-02-27 |
3 |
¤ 146.06 |
Austria |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 11029 |
CHOPS |
4 |
2020-03-04 |
3 |
¤ 12.76 |
Brazil |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 11032 |
WHITC |
2 |
2020-02-28 |
3 |
¤ 3.67 |
Sweden |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| 11033 |
RICSU |
7 |
2020-02-28 |
1 |
¤ 55.28 |
France |
juZ7IWw53MTMIYXVY6qmMV7JrHJxP7XEFpDshnrC/QQ=-~Als8i9nFtqNFgF5UypxV1g== |
| ProductID |
ProductName |
SupplierID |
CategoryID |
QuantityPerUnit |
UnitPrice |
ProductCost |
Discontinued |
| 7 |
Uncle Bob's Organic Dried Pears |
3 |
7 |
12 - 1 lb pkgs. |
¤ 30.00 |
¤ 22.50 |
false |
| 11 |
Queso Cabrales |
5 |
4 |
1 kg pkg. |
¤ 21.00 |
¤ 16.00 |
false |
| 17 |
Alice Mutton |
7 |
6 |
20 - 1 kg tins |
¤ 39.00 |
¤ 20.70 |
true |
| 19 |
Teatime Chocolate Biscuits |
8 |
3 |
10 boxes x 12 pieces |
¤ 9.20 |
¤ 4.50 |
false |
| 26 |
Gumbär Gummibärchen |
11 |
3 |
100 - 250 g bags |
¤ 31.23 |
¤ 22.80 |
false |
| 30 |
Nord-Ost Matjeshering |
13 |
8 |
10 - 200 g glasses |
¤ 25.89 |
¤ 12.20 |
false |
| 33 |
Geitost |
15 |
4 |
500 g |
¤ 2.00 |
¤ 2.01 |
false |
| 36 |
Inlagd Sill |
17 |
8 |
24 - 250 g jars |
¤ 19.00 |
¤ 18.51 |
false |
| 38 |
Côte de Blaye |
18 |
1 |
12 - 75 cl bottles |
¤ 263.00 |
¤ 263.01 |
false |
| 40 |
Boston Crab Meat |
19 |
8 |
24 - 4 oz tins |
¤ 18.40 |
¤ 17.91 |
false |
| 42 |
Singaporean Hokkien Fried Mee |
20 |
5 |
32 - 1 kg pkgs. |
¤ 14.00 |
¤ 13.51 |
true |
| 53 |
Perth Pasties |
24 |
6 |
48 pieces |
¤ 32.80 |
¤ 32.31 |
true |
| 54 |
Tourtière |
25 |
6 |
16 pies |
¤ 7.45 |
¤ 6.96 |
false |
| 55 |
Pâté chinois |
25 |
6 |
24 boxes x 2 pies |
¤ 24.00 |
¤ 23.51 |
false |
| 56 |
Gnocchi di nonna Alice |
26 |
5 |
24 - 250 g pkgs. |
¤ 38.00 |
¤ 37.51 |
false |
| 59 |
Raclette Courdavault |
28 |
4 |
5 kg pkg. |
¤ 55.00 |
¤ 54.51 |
false |
| 63 |
Vegie-spread |
7 |
2 |
15 - 625 g jars |
¤ 43.90 |
¤ 43.41 |
false |
| 68 |
Scottish Longbreads |
8 |
3 |
10 boxes x 8 pieces |
¤ 12.50 |
¤ 12.01 |
false |
| 69 |
Gudbrandsdalsost |
15 |
4 |
10 kg pkg. |
¤ 36.00 |
¤ 35.51 |
false |
| 72 |
Mozzarella di Giovanni |
14 |
4 |
24 - 200 g pkgs. |
¤ 34.00 |
¤ 34.31 |
false |
| ShipperID |
CompanyName |
Phone |
mSysRowId |
| 1 |
Speedy Express |
(503) 555-9831 |
V7NObZC6nJHo3I6ceBu+u7wLY5T9qIE5BJnJf7+qAO0=-~Z/gq0SnQDRcCnBhkWOhdOg== |
| 2 |
United Package |
(503) 555-3199 |
V7NObZC6nJHo3I6ceBu+u7wLY5T9qIE5BJnJf7+qAO0=-~Z/gq0SnQDRcCnBhkWOhdOg== |
| 3 |
Federal Shipping |
(503) 555-9931 |
V7NObZC6nJHo3I6ceBu+u7wLY5T9qIE5BJnJf7+qAO0=-~Z/gq0SnQDRcCnBhkWOhdOg== |
| 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;
lacey.xyY
