Business Question

Let’s return to our database for SongBird Bakery.

Now that you know what it takes to create a query, use the two tables below to answer the following questions.

• Orders Table.xlsxCustomers.xlsx

1. Describe the query you would run to determine which customers have placed an order but still haven’t paid. What values from each table need to be used?
2. Describe the query you would run to determine how many customers on the mailing list have placed orders. What values from each table need to be used?

Now put yourself in the shoes of the bakery manager.

Think of two other scenarios you would encounter in your job and how you would use the database to help you.

For each scenario, describe how you would use the database to help you. Provide the following:

• Describe the scenario you have come up with.
• What values would you need and what tables are those values found in?
• Are there any other steps you need to complete to provide the information needed?

Your answers should be written as a summary in paragraph form.

___________________________________________________________________________________________________

Your project for this course will be to develop a presentation About an Existing Company’s Website

You will be using Microsoft PowerPoint to complete your project.

Week 3: Products and Services

As a reminder, each week you will be using the organization you chose in Week 1.

The third part of your project will be the Products & Services page of your organization. Your product page should give visitors a general overview of all that you offer. It should convey the bigger picture so that with a more holistic view of your business, visitors can then choose which specific products they want to pursue.

Create a presentation about the organization you chose Products and/or Services page. Review the Products and/or Services page by including, at minimum the following:

• Describe the company’s products and/or services
• Why should a customer buy from the organization?
• Are the products and/or services able to purchase through e-commerce?
• What are the advantages and disadvantages of e-commerce?

Page 1
ID First Name Last Name Street Address City
1 Tracey Beckham 7 East Walker Dr. Raleigh
2 Lucinda George 789 Brewer St. Cary
3 Jerrod Smith 211 St. George Ave. Raleigh
4 Brett Newkirk 47 Hillsborough St. Raleigh
5 Chloe Jones 23 Solo Ln. Raleigh
6 Quinton Boyd 4 Cypress Cr. Durham
7 Alex Hinton 1011 Hodge Ln. Cary
8 Nisha Hall 123 Huntington St. Raleigh
9 Hillary Clayton 2516 Newman Raleigh
10 Kiara Williams 9014 Miller Ln. Durham
11 Katy Jones 456 Denver Rd. Cary
12 Beatrix Joslin 85 North West St. Raleigh
13 Mariah Allen 12 Jupe Raleigh
14 Jennifer Hill 2100 Field Ave. Raleigh
15 Jaleel Smith 123 Hill Top Drive Garner
16 Cody Hayes 65 North St. Raleigh
17 Amaya Gibson 5 West St. Raleigh
18 Cynthia Love 7825 Venice Ct. Raleigh
19 Cindy Freeman 78-A Meadowview Ln. Raleigh
20 Barbara Jameson 29 North Luke Ct. Raleigh
29 Bob Jones 63-C Chapel Ct. Durham
30 Juanita Williams 123 Garden Plow Way Raleigh
31 Sara Thomas 127 South Pejulup Ln. Raleigh
32 Larry Binder 124 Heuristic Way Raleigh
33 Samantha Ferguson 2380 New Cove Rd. Garner
35 Patti Cheng 9 Atlantic Blvd Raleigh
36 Greg Newton 2520 Hopkins Rd. Raleigh
37 Carol Allenson 3201 Glenwood Ave. Unit A Raleigh
38 Zoey Altman 817 Hillsborough St. Apt E102 Raleigh
39 Danny Haverford 202 Cedar Ln. Raleigh
40 Vig Aurelio 53 Pine St. Raleigh
41 Jeffery Bergman 1245 Ross Park Dr. Raleigh
42 William Bittiman 1122 Glenwood Ave. Raleigh
43 Megan Draper 311 Cook St. Raleigh
Page 2
44 Dick Whitman 105 David St. Raleigh
45 Marjan Jameson 202 C St. Unit A Raleigh
46 Colin Hopkins 321 E. Edenton St. Raleigh
47 Hakim Auden 921 Dawson St. Raleigh
48 Pilar Semana 72 Oberlin Rd. Raleigh
49 Eliza Harris 989 Cameron Ave. Raleigh
50 Chloe Ford 3456 Glenwood Ave. Raleigh
51 Juanita Harris 43 Prosperity Way Raleigh
52 Denver Ferguson 856 Cook St. Raleigh
53 John Emory 99 Hillsborough St. Garner
54 Ebony Farmer 872 W. Morgan St. Raleigh
55 Kim Doe 553 Wayne St. Raleigh
56 Coretta Diaz 781 Bloodsworth St. Raleigh
57 Victor Denver 31 St. Mary’s St. Raleigh
58 Hamish David 21 Cameron Ct. Raleigh
59 Erin Counts 763 E. West St. Raleigh
60 Harris Collman 455 E. Edenton St. Raleigh
61 Melissa Chantay 3201 Glenwood Ave. Unit C Raleigh
62 Emmanual Colin 11 Sassafras Way Raleigh
63 Illa Carlson 563 Oberlin Rd. Raleigh
64 Tyrone Rodgers 453 Pine St. Raleigh
65 Roger Robinson 634 Oak Ave. Raleigh
66 Robert Jenkins 44 Hickory Rd. Raleigh
67 Joy Zachman 897 Lee St. Raleigh
68 Frances Trenton 901 Kenan Rd. Raleigh
69 Latavia Rienstra 3 McIver Ct. Raleigh
70 Kurtis Temple 173 Cobb Rd. Raleigh
71 Lashaunda White 211 Hinton St. Raleigh
72 Lieselotte Tempie 12 Spencer Ave. Chapel Hill
73 Sula Smart 56 Dey Rd. Raleigh
Page 3
74 Jude Smith 929 Greenlaw Dr. Raleigh
75 Katharine Kellerman 76 Murphy Ave. Cary
76 Ruiari O’Brien 100 Aycock St. Raleigh
77 Tyra Kirby 8700 Stacey Rd. Raleigh
78 Michiko Akiwana 901 Glenwood Ave. Raleigh
79 Betty Potter 80 Greene St. Raleigh
80 Elizabeth Loges 44 Steven Rd. Raleigh
81 Janie Widby 3100 St. Mark’s St. Raleigh
82 Trudy Brie 25 Hillsborough St. Raleigh
83 Jane Sterling 331 W. Hargett St. Raleigh
84 Magda Sremski 98 Tyler St. Raleigh
85 Peggy Moss 1130 Jackson St. Raleigh
86 Elisabeth Olsen 4325 W. King St. Garner
87 Robert Armisen 21 MLK Blvd. Chapel Hill
88 Don Hamm 1221 Coretta Scott Way Cary
89 Roger Slattery 82 Parks St. Raleigh
90 Joan Hendricks 60 Glenwood Ave Apt E106 Raleigh
91 Pete Karthiser 98 Pale View Rd. Raleigh
92 Raphaelle Duvalier 922 Hill St. Raleigh
93 Bruno D’Haussy 21 Bird St. Raleigh
94 Margot D’Illiers 532 Chronicle Way Raleigh
95 Florent Marais 53 Ada St. Raleigh
96 Erwan Haussman 918 Lonesome Dove Rd. Raleigh
97 Rodrigue Bolougne 49 Mockingbird Way Raleigh
98 Alix Mars 9211 Dolores Rd. Raleigh
99 Camille Germain 902 Haze St. Raleigh
100 Capucine Desetoiles 122 MLK Blvd Raleigh
101 Colombane Lafleur 48 St. Louis Way Raleigh
102 Theodore Achi 120 Baker St. Raleigh
103 Remy Labiere 910 Mint St. Durham
104 Lebron Wade 1002 Parsley Way Raleigh
105 Dwyane James 4221 Basil Ct. Cary
106 Joakim Love 449 Thyme Ln. Raleigh
107 Kevin Noah 41 Pepper Rd. Raleigh
108 Blake Bryant 536 Abbey Rd. Raleigh
109 Kobe Griffins 789 Penny Ln. Raleigh
110 Michael Turkolou 4 Strawberry Ct. Raleigh
111 Hedo Jordan 637 Lucy Ln. Raleigh
112 Dwight Parker 8 Rocky Way Raleigh
113 Tony Howard 1831 Rubber Rd. Raleigh
114 Kendra Rosche 129 Anna St. Raleigh
115 Jedd Fish 62 Glenwood Ave Apt A255 Raleigh
116 Julie Tilley 79 Murphy Ave. Raleigh
117 Jeanne Daugherty 105 Aycock St. Chapel Hill
Page 4
118 Jake Szypulski 87 Stacey Rd. Raleigh
119 Eric Oglesby 91 Glenwood Ave. Durham
120 Jacek Slobodowski 7 Greene St. Cary
121 Filip Piatek 99 Steven Rd. Raleigh
122 Lew Riley 31 St. Mark’s St. Raleigh
123 Maciej Pajak 21 Hillsborough St. Apt. 6 Raleigh
124 Andrew Bedinger 28 Juliane St. Raleigh
125 George Wein 33 Bartholomew Ln. Raleigh
126 Dane Raught 54 Micah Rd. Raleigh
127 Ed Bradshaw 3221 St. Matthew’s St. Raleigh
128 Will Martel 910 Elizabeth Lane Raleigh
129 Yann Augerot 88 Carolina Rd. Raleigh
130 Kellen Leigh 12 Florida St. Raleigh
131 Andrzej Wujek 424 Georgia Ct. Raleigh
132 Jaquon Whitty 82 Massachusetts Ave. Raleigh
133 Zavion Storey 1834 Dakota St. Durham
134 Jar’Nae Bryson 2 Vermont Rd. Raleigh
135 Takevia Watson 9244 Pennsylvania St. Raleigh
136 Xy’nya Bell 23 Colorado Ct. Raleigh
137 Kle’Aija White 911 Oregon Tr. Cary
138 Lane Hollings 7 Mississippi Ln. Raleigh
139 Matthew Tappen 44 Connecticut Blvd. Raleigh
140 Alyssa Ullman 3321 Bronwen Ct. Raleigh
141 Ta’Nyia Jackson 40 Virginia Rd. Raleigh
142 I’mmoni Price 788 Cudie Ln. Raleigh
143 Laila Blue 7 New St. Raleigh
144 Makeda Niebo 412 Dean St. Raleigh
145 Xiaoxi Zheng 90 Hillsborough St. Raleigh
146 Xiaolin Tu 1243 W. Morgan St. Raleigh
147 Magda Sremski 544 Wayne St. Raleigh
148 Hugh Jodey 531 Bloodsworth St. Raleigh
149 Sasha Bright 4 St. Mary’s St. Raleigh
150 Brigit Sigrudsdatter 55 Cameron Ct. Cary
151 Vladimir Tolstoy 19 E. West St. Raleigh
152 Leo Nabokov 532 E. Edenton St. Raleigh
153 Carson Woolf 3541 Glenwood Ave. Unit C Raleigh
154 Virginia McCullers 98 Sassafras Way Raleigh
155 Graham Dosty 43 Oberlin Rd. Raleigh
156 Fyodor Greene 54 Pine St. Raleigh
157 Haruki Ido 63 Oak Ave. Raleigh
158 Thornton Lee 411 Hickory Rd. Raleigh
159 Harper Wilder 843 Lee St. Raleigh
160 Langston Brooks 971 Kenan Rd. Garner
161 Gwendolyn Hughes 334 McIver Ct. Chapel Hill
Page 5
162 Maya Kafka 453 Cobb Rd. Raleigh
163 Franz Angelou 291 Hinton St. Raleigh
164 Sawyer Brown 125 Spencer Ave. Raleigh
165 Jack Ford 568 Dey Rd. Raleigh
166 Kate Locke 8779 Greenlaw Dr. Raleigh
167 John Broad 7 Murphy Ave. Raleigh
168 Shannon Opley 97 Aycock St. Raleigh
169 Peter Demarcy 70 Stacey Rd. Raleigh
170 Walt James 67 East Walker Dr. Raleigh
171 Sayid Rayeen 7549 Brewer St. Raleigh
172 Hugo Ramierez 222 St. George Ave. Raleigh
173 David Barrett 430 Hill St. Raleigh
174 Benjamin Linus 3 Solo Ln. Raleigh
175 Cassandra Rousseau 443 Cypress Cr. Raleigh
176 Esther Yaron 166 Hodge Ln. Raleigh
177 Anisa Naser 62 Huntington St. Raleigh
178 Brigid Ellison 256 Newman Dr. Raleigh
179 Melissa White 906 Miller Ln. Raleigh
180 Malik Reynolds 457 Denver Rd. Raleigh
181 Windy Shaw 8 Chavez St. Raleigh
182 Christopher Peyton-Gomez 16 Jupe Dr. Raleigh
183 Michael Lazar 8 July Ave. Raleigh
184 Christiana Chen 12 Hill Top Dr. Raleigh
185 Sidney Kelly 66 North St. Raleigh
186 Chevonne Means 97 West St. Raleigh
187 Samantha Bell 75 Venice Ct. Raleigh
188 Nathan Albee 76-C Meadowview Ln. Raleigh
189 Avery Kelly 32 North Luke Ct. Raleigh
190 Matt Benson 69-B Chapel Ct. Raleigh
191 Gabriel Del Toro 92 Garden Plow Way Raleigh
192 James Panarello 198 Jackson St. Raleigh
193 Chantal Weller 234 W. King St. Raleigh
194 Derek MacDonald 243 MLK Blvd. Chapel Hill
195 Kris Ackerman 1311 Coretta Scott Way Raleigh
196 Jordan Weller 8 Parks St. Raleigh
197 Regina Olivera 60 Glenwood Ave Apt A121 Durham
198 Alex Yuen 8 Marcus Ln. Cary
199 Lia Richards 890 Garvey St. Durham
200 Karla Nichols 981 DuBois Ct. Durham
201 Tyrese Hanlon 31 Crispus Ct. Apt B Cary
202 Juan Flores 122 Luna St. Durham
204 Tobias Inman 34 Peace St. Raleigh
205 Teyonah Lamb 321 Home Dr. Raleigh
206 Gregoire Pick 604 Hatsy Way Charlotte
Page 6
207 Mallary Pont 91 Julianna Way Charlotte
208 Rajeev Parthasarathy 1009 Raleigh Street Hillsborough
209 Will Good 38 Learnfree St. Raleigh
212 David Barrett 434 Hill St. Raleigh
Page 7
State Zip Code Email
NC 27612 beck@email.com
NC 27513 lugeo@email.com
NC 27610 texj@email.com
NC 27608 newkb@email.com
NC 27609 lo@email.com
NC 27714 denqui@email.com
NC 27513 dhoda@email.com
NC 27612 hall@email.com
NC 27606 mshill@email.com
NC 27713 rogki@email.com
NC 27513 yjonesk@email.com
NC 27606 jozbee@email.com
NC 27605 mallen@email.com
NC 27609 hillj@email.com
NC 27610 jsmi@email.com
NC 27609 richhi@email.com
NC 27612 alg@email.com
NC 27605 topv@email.com
NC 27609 cindyfree@email.com
NC 27609 bjaes@email.com
NC 27714 Bob_ready2read@email.com
NC 27609 Juanita_ready2read@email.com
NC 27603 Sarasara@email.com
NC 27609 Larry87@email.com
NC 27529 Sferguson@email.com
NC 27608 Jamie_X@email.com
NC 27615 ChengPat@email.com
NC 27607 GregNew@email.com
NC 27605 callenson@email.com
NC 27609 zalt@email.com
NC 27612 daurelio@email.com
NC 27609 bigvig22@email.com
NC 27609 jefejeff@email.com
NC 27615 willbit@email.com
Page 8
NC 27607 megansays@email.com
NC 27608 callmedon@email.com
NC 27609 margy@email.com
NC 27609 colin_hopkins@email.com
NC 27603 hauden@email.com
NC 27609 eharris@email.com
NC 27608 chloedit@email.com
NC 27603 juaniii@email.com
NC 27605 denverferg@email.com
NC 27529 emoryj@email.com
NC 27609 ebonique@email.com
NC 27612 kdoe@email.com
NC 27609 corettadee@email.com
NC 27609 vickdenver@email.com
NC 27603 hamman@email.com
NC 27608 ecounts@email.com
NC 27608 harrisc@email.com
NC 27615 chantayay@email.com
NC 27603 oemmanual@email.com
NC 27609 illac@email.com
NC 27603 tyroner@email.com
NC 27612 rogrob@email.com
NC 27612 rjenks@email.com
NC 27609 jzman@email.com
NC 27609 grammasangels@email.com
NC 27607 latayy@email.com
NC 27609 kurtemple@email.com
NC 27607 la_shaun@email.com
NC 27517 lieselotte@email.com
NC 27609 sulas@email.com
Page 9
NC 27609 judesm@email.com
NC 27513 katharine_kellerman@email.com
NC 27615 ruiaribig@email.com
NC 27607 notthattyra@email.com
NC 27609 michichan@email.com
NC 27615 bettyandjack@email.com
NC 27606 lizzyloges@email.com
NC 27615 janie56@email.com
NC 27609 trudywife@email.com
NC 27609 rogersjane@email.com
NC 27612 magdayum@email.com
NC 27609 peggycopywriter@email.com
NC 27529 lissyolsen@email.com
NC 27514 robarmisen@email.com
NC 27513 donhamm@email.com
NC 27609 rslat@email.com
NC 27607 joanie@email.com
NC 27609 karthiser@email.com
NC 27609 raphduvalier@email.com
NC 27603 brunodh@email.com
NC 27615 margotmdr@email.com
NC 27607 florentdit@email.com
NC 27609 ptiterwan@email.com
NC 27607 rody@email.com
NC 27608 alixla@email.com
NC 27606 camillge@email.com
NC 27609 capustar@email.com
NC 27615 colomblafleur@email.com
NC 27609 tachi@email.com
NC 27714 remybeer@email.com
NC 27605 lebron@email.com
NC 27513 dwyane@email.com
NC 27609 joakimjoking@email.com
NC 27603 kno@email.com
NC 27609 blakeyblake@email.com
NC 27609 kobegrif@email.com
NC 27615 elturk@email.com
NC 27609 hedohedo@email.com
NC 27609 dparker@email.com
NC 27608 tonyhoward@email.com
NC 27607 krosche@email.com
NC 27609 fish_jedd@email.com
NC 27609 juilley@email.com
NC 27514 jdot@email.com
Page 10
NC 27609 jszyp@email.com
NC 27701 eoglesby@email.com
NC 27513 jacekslo@email.com
NC 27607 piatekfil@email.com
NC 27609 lewisriley@email.com
NC 27605 maciej@email.com
NC 27609 andrewbed@email.com
NC 27615 gwein@email.com
NC 27608 rdane@email.com
NC 27608 bredshaw@email.com
NC 27612 willmartel@email.com
NC 27603 augeryann@email.com
NC 27609 kellenleigh@email.com
NC 27606 andrzej@email.com
NC 27609 jaqqq@email.com
NC 27714 zavistor@email.com
NC 27609 jar.nae@email.com
NC 27609 takewats@email.com
NC 27615 xynia@email.com
NC 27513 kleaija@email.com
NC 27607 lhollings@email.com
NC 27609 mattapp@email.com
NC 27609 allyulls@email.com
NC 27605 taniyaj@email.com
NC 27609 immonioni@email.com
NC 27601 lblue@email.com
NC 27601 niebom@email.com
NC 27603 askxiaoxi@email.com
NC 27609 tuxi@email.com
NC 27612 gollymissmolly@email.com
NC 27607 hugeodie@email.com
NC 27607 sbright@email.com
NC 27514 brigitsigrudsdatter@email.com
NC 27609 vladtol@email.com
NC 27609 leonabo@email.com
NC 27615 carsonwoolf@email.com
NC 27601 virgymcullers@email.com
NC 27609 dosty@email.com
NC 27608 fyodoro@email.com
NC 27616 harukido@email.com
NC 27609 thorntonly@email.com
NC 27605 harperwild@email.com
NC 27529 langstonb@email.com
NC 27514 gwendolynlambhughes@email.com
Page 11
NC 27608 mayakaf@email.com
NC 27607 franzangelou@email.com
NC 27609 sawyerb@email.com
NC 27615 jfford@email.com
NC 27606 katelocke@email.com
NC 27615 jbroad@email.com
NC 27609 shopley@email.com
NC 27609 demarcypete@email.com
NC 27609 walterrjames@email.com
NC 27608 sayid84@email.com
NC 27609 hellohugo@email.com
NC 27609 cataleeeeen@email.com
NC 27607 evilben@email.com
NC 27615 cassierousseau@email.com
NC 27608 estheryaron@email.com
NC 27601 anaser@email.com
NC 27601 briggyellison@email.com
NC 27612 mwhite@email.com
NC 27601 mreynolds@email.com
NC 27609 mreynolds@email.com
NC 27612 shawywind@email.com
NC 27513 chrispg@email.com
NC 27609 laserlazar@email.com
NC 27609 chencris@email.com
NC 27601 sidkelly@email.com
NC 27609 chevvymeans@email.com
NC 27601 samabell@email.com
NC 27616 natealbee@email.com
NC 27616 kavery@email.com
NC 27609 bensonm@email.com
NC 27616 gabidt@email.com
NC 27608 panarello@email.com
NC 27707 youngmacdonald@email.com
NC 27605 krack@email.com
NC 27609 jwell@email.com
NC 27701 queenregina@email.com
NC 27513 yualex@email.com
NC 27714 lialialia@email.com
NC 27609 karlacheer92@email.com
NC 27513 tyreezzz@email.com
NC 27714 juanflo@email.com
NC 27603 toby@email.com
NC 27603 tlamb@email.com
NC 28203 gre@email.com
Page 12
NC 28201 charchar@email.com
NC 27278 rajey@email.com
NC 27701
NC 27609 davidbarrett@email.com
Page 13
Add to Mailing List? Phone Number Other Notes
No 919-555-2314
Yes- Weekly 919-555-4534
No 919-555-4564
No 919-555-7653
No 919-555-8658
Yes- Weekly 919-555-5112
No 919-555-5460
Yes- Special Offers Only 919-555-5753
No 919-555-9745
Yes- Weekly 919-555-8975
No 919-555-2332
Yes- Special Offers Only 919-555-1123
No 919-555-3432 Nut allergy
No 919-555-5467
No 919-555-7755
No 919-555-5434
Yes- Special Offers Only 919-555-7565
Yes- Special Offers Only 919-555-4655
No 919-555-7890
No 919-555-2222 Diabetic- Make all w/substitute sugar
No 919-555-2121
No 919-555-4334
No 919-555-5643
Yes- Special Offers Only 919-555-5657
No 919-555-6576
No 919-555-6666
No 919-555-4585
Yes- Special Offers Only 919-555-7575 The boss’s mom- 50% discount
No 919-555-6688
No 919-555-7778
Yes- Special Offers Only 919-555-8789
No 919-555-4644
No 919-555-6888
Yes- Special Offers Only 919-555-0783
Page 14
No 919-555-5042
No 919-555-2044
Yes- Special Offers Only 919-555-0544
Yes- Special Offers Only 919-555-0045
Yes- Special Offers Only 919-555-5404
Yes- Special Offers Only 919-555-0455
Yes- Special Offers Only 919-555-0464
No 919-555-0475
No 919-555-0402
Yes- Special Offers Only 919-555-0007
Yes- Special Offers Only 919-555-5040
No 919-555-5560
No 919-555-5721
No 919-555-5470
No 919-555-6580
Yes- Special Offers Only 919-555-5070
Yes- Special Offers Only 919-555-0570
No 919-555-5750
Yes- Special Offers Only 919-555-0575
Yes- Special Offers Only 919-555-0668
No 919-555-0870
Yes- Special Offers Only 919-555-6860
No 919-555-6807
Yes- Special Offers Only 919-555-0858
No 919-555-0509
Yes- Special Offers Only 919-555-7780
No 919-555-8704
No 919-555-7895
No 919-555-4789
No 919-555-4562
Page 15
No 919-555-4265
No 919-555-4526
No 919-555-4124
No 919-555-4354
No 919-555-4102
No 919-555-4021
No 919-555-4780
No 919-555-1025
No 919-555-1021
No 919-555-1026
No 919-555-1024
No 919-555-1478
No 919-555-1475
No 919-555-1452
No 919-555-1458
No 919-555-1456
No 919-555-1459
No 919-555-1453
No 919-555-1547
No 919-555-1548
No 919-555-1542
No 919-555-1587
No 919-555-1574
No 919-555-1578
No 919-555-1589
No 919-555-1586
No 919-555-1563
No 919-555-1562 Rude!
No 919-555-1530
No 919-555-1536
No 919-555-1520
No 919-555-1526
No 919-555-1524
No 919-555-1523
No 919-555-1502
No 919-555-1018
No 919-555-1020
No 919-555-0012
No 919-555-1002
No 919-555-1032
No 919-555-1054
No 919-555-1580
No 919-555-1058
No 919-555-1096
Page 16
No 919-555-1074
No 919-555-2085
No 919-555-3021
No 919-555-1088
No 919-555-8050
No 919-555-9059
No 919-555-1045
No 919-555-3302
No 919-555-0557
No 919-555-0647
No 919-555-0356
No 919-555-0657
No 919-555-0687
No 919-555-0450
No 919-555-0500
No 919-555-0578
No 919-555-0576
No 919-555-0579
No 919-555-0758
No 919-555-0213
No 919-555-0214
No 919-555-0324
No 919-555-5778
No 919-555-5998
No 919-555-6882
No 919-555-6100
No 919-555-6540
No 919-555-2786
No 919-555-2005
No 919-555-4001
No 919-555-1001
No 919-555-1400
No 919-555-0089
No 919-555-0033
No 919-555-0444
No 919-555-0440
No 919-555-0142
No 919-555-0047
No 919-555-9000
No 919-555-8000
No 919-555-7000
No 919-555-6006
No 919-555-5000
No 919-555-4000
Page 17
No 919-555-2899
No 919-555-2000
No 919-555-1000
No 919-555-0999
No 919-555-0998
No 919-555-0997
No 919-555-0666
No 919-555-0665
No 919-555-6640
No 919-555-0664
No 919-555-0663
No 919-555-0662
No 919-555-0661
No 919-555-0660
No 919-555-3000
No 919-555-3001
No 919-555-3002
No 919-555-3003
No 919-555-3004
No 919-555-3005
No 919-555-3006
No 919-555-3007
No 919-555-3008
No 919-555-3009
No 919-555-7008
No 919-555-7009
No 919-555-7010
No 919-555-7011
No 919-555-7012
No 919-555-1023
No 919-555-7023
No 919-555-7024
No 919-555-7025
No 919-555-7068
No 919-555-7069
No 919-555-7070
No 919-555-8080
No 919-555-9090
No 919-555-4040
No 919-555-5050
No 919-555-6060
No 919-555-0000 Allergic to everything
No 919-555-8801
No 336-555-3132
Page 18
No 336-555-2211
No 919-555-0321
No 919-555-9455
No 919-555-0662
Page 1
ID Customer ID Paid Pre Order
5 44 TRUE FALSE
6 136 TRUE TRUE
7 131 TRUE FALSE
8 145 TRUE TRUE
9 47 TRUE FALSE
10 38 TRUE FALSE
11 92 TRUE TRUE
12 38 TRUE FALSE
13 139 TRUE TRUE
14 130 TRUE FALSE
15 129 TRUE TRUE
16 124 TRUE FALSE
17 163 TRUE FALSE
18 96 TRUE FALSE
19 78 TRUE FALSE
20 153 TRUE FALSE
21 71 TRUE TRUE
22 176 TRUE FALSE
23 149 TRUE FALSE
24 96 TRUE TRUE
25 10 TRUE TRUE
26 100 TRUE TRUE
27 125 TRUE TRUE
28 104 TRUE TRUE
29 97 TRUE TRUE
30 101 TRUE TRUE
31 44 TRUE TRUE
32 121 TRUE TRUE
33 187 TRUE TRUE
34 92 TRUE TRUE
35 101 FALSE FALSE
36 106 TRUE FALSE
37 81 TRUE FALSE
38 1 TRUE FALSE
Page 2
39 106 TRUE TRUE
40 82 TRUE FALSE
41 111 TRUE TRUE
42 37 TRUE FALSE
43 57 TRUE FALSE
44 191 TRUE FALSE
45 117 TRUE TRUE
46 54 TRUE FALSE
47 146 TRUE FALSE
48 86 TRUE TRUE
49 118 TRUE TRUE
50 188 FALSE FALSE
51 150 FALSE FALSE
52 198 FALSE FALSE
53 194 FALSE FALSE
54 120 FALSE FALSE
55 119 FALSE TRUE
56 75 FALSE FALSE
57 197 FALSE FALSE
58 133 FALSE FALSE
59 72 FALSE FALSE
60 53 FALSE FALSE
61 208 FALSE FALSE
62 209 FALSE FALSE
63 37 TRUE TRUE
64 129 TRUE FALSE
Page 3
Notes Pickup Date
04-Dec-20
For a birthday party– cake should read, “Happy Birthday, Daddy!” 09-Dec-20
04-Dec-20
For a reception at the J. Ikiba Gallery 10-Dec-20
14-Dec-20
15-Dec-20
For a holiday party 15-Dec-20
16-Dec-20
For a kindergarten party. Write, “Happy 6th Birthday, Matthew!” on the cake
and draw a rabbit in icing next to the text.
16-Dec-20
17-Dec-20
For a holiday party 17-Dec-20
17-Dec-20
18-Dec-20
For a Christmas party 18-Dec-20
Cake should read, “Congratulations, Yuki!” 18-Dec-20
18-Dec-20
For an office party 19-Dec-20
Extra icing 18-Jan-20
20-Dec-20
Decorate cake with the following names: “Edouard,” “Arnaud,” “Erwan,”
“Celine,” and “Camille”
23-Dec-20
Christmas 23-Dec-20
Add text, “Joyeaux Noël 2010” 23-Dec-20
Christmas- Write “Happy Birthday Jesus” on the Carrot Cake 23-Dec-20
Christmas- Tie boxes up with ribbon 23-Dec-20
Christmas- write “Merry Christmas to All” on the cake. 23-Dec-20
Vary decorative details on the cakes– different colored flowers, placement of
moss, etc
24-Dec-20
24-Dec-20
24-Dec-20
24-Dec-20
24-Dec-20
Christmas. Decorate Buche de Noel with red flowers and text, “Joyeux Noël
et Bonne Année”
24-Dec-20
24-Dec-20
23-Dec-20
24-Dec-20
Page 4
Apparently, he plans to eat most of this himself?! Maybe that was a joke… 24-Dec-20
Customer came in an hour before closing time and got angry that we were
sold out of Pecan and Pumpkin Pies by that point. Apologized and advised her
to pre-order next Christmas.
24-Dec-20
For a NYE party 30-Dec-20
30-Dec-20
30-Dec-20
30-Dec-20
For a NYE party 31-Dec-20
31-Dec-20
31-Dec-20
For the Mayor’s NYE Gala– arrange on best platters and deliver. No extra
charge for an order this big. Extra decoration, etc– we want this to look
REALLY good.
31-Dec-20
31-Dec-20
04-Jan-21
02-Mar-21
03-Mar-21
02-Mar-21
04-Mar-21
12-Mar-21
10-Mar-21
11-Mar-21
17-Mar-21
17-Mar-21
15-Mar-21
14-Mar-21
Yes! You found me. Congratulations on building your first query! 🙂
For a St. Patrick’s Day party. Make everything we can green (green food
coloring to cake and cookie dough, green filling in cream puffs) and add on
green sprinkles where appropriate.
16-Mar-21
02-Dec-21