Question
ChocRepNum (Primary Key) LastName FirstName Street City State PostalCode StartDate 31 Rivera Haydee 325 Twiddy St. Avondale IN 60311 6/3/2013 35 Simson Mark 1467 Hartwell
ChocRepNum (Primary Key) | LastName | FirstName | Street | City | State | PostalCode | StartDate |
31 | Rivera | Haydee | 325 Twiddy St. | Avondale | IN | 60311 | 6/3/2013 |
35 | Simson | Mark | 1467 Hartwell St. | Walker | IN | 46004 | 5/19/2015 |
42 | Lu | Peter | 5624 Murray Ave. | Davidson | IN | 46007 | 8/3/2015 |
58 | Murowski | Karen | 168 Truesdale Dr. | Carlton | IL | 60313 | 11/9/2016 |
Part 3 Create the following three queries. Refer to the hard copy pages of the table to determine what should result BEFORE attempting your queries.
1) Find all companies that have a Chocolate Representative # of 58. Include Company ID, Company, and Phone #. Do not show the ChocRep# in the results. Save the query as Query 1.
2) Sort all the companies in alphabetical order. Include company, address, city, state, and zip code. Save the query as Query 2.
3) This one is challenging! Create a query that includes all of the companies in New England (New Hampshire, Vermont, Connecticut, Massachusetts, Rhode Island, and Maine. Save the query as Query 3.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started