The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He
Question:
1. List the name of each trip that does not start in New Hampshire (NH).
2. List the name and start location for each trip that has the type Biking.
3. List the name of each trip that has the type Hiking and that has a distance of greater than six miles.
4. List the name of each trip that has the type Paddling or that is located in Vermont (VT).
5. How many trips have a type of Hiking or Biking?
6. List the trip name, type, and maximum group size for all trips that have Susan Kiley as a guide.
7. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
8. List the name of each trip that has the type Hiking and that is guided by Rita Boyers.
9. How many trips originate in each state?
10. How many reservations include a trip with a price that is greater than $20 but less than $75?
11. List the reservation ID, customer last name, and the trip name for all reservations where the number of persons included in the reservation is greater than four.
12. List the trip name, the guide€™s first name, and the guide€™s last name for all trips that originate in New Hampshire (NH). Sort the results by guide€™s last name within trip name.
13. List the reservation ID, customer number, customer last name, and customer first name for all trips that occur in July 2016.
14. Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result by the number of persons included in the reservation. List the reservation ID, trip name, customer€™s last name, customer€™s first name, and total cost for all reservations where the number of persons is greater than four. Use the column name TotalCost for the calculated field.
15. Create a new table named Solo that includes the reservation ID, trip ID, trip date, trip price, other fees, and customer number for all reservations that are for only one person.
16. Use an update query to change the OtherFees value in the Solo table to $5.00 for all records on which the OtherFees value is $0.00.
17. Use a delete query to delete all trips in the Solo table where the trip date is 9/12/2016.
18. There are multiple ways to create the query in Step 13. Write the SQL command that you used and then write an alternate command that also would obtain the correct result.
19. The following SQL code produces an error message. What is wrong with the code and how would you correct it?
SELECT ReservationID, TripID, TripName
FROM Reservation, Trip
WHERE Reservation.TripID¼Trip.TripID;
Figure 1-15
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Data files consist of copies of the TAL Distributors Colonial Adventure Tours and Solmaris Condominium Group databases that are usable in Access 2010 ...View the full answer
Answered By
KAMRAN FATEH
Hi, my name is Kamran Fateh. I have completed my MPhil in Organic Chemistry from a well-reputed university in Asia. I love to talk and ask questions, and I encourage my students to do the same. I have an excellent track record in improving students' grades and confidence. I have been assisting American and Canadian students for the last 5 years.
I am an expert in organic I, organic II, and general chemistry. I have read the latest foreign books like Organic Chemistry by David Klein, McMurry Organic Chemistry, Paula Yurkanis Bruise, L.G. Wade, William Ogilive, and Chemistry of Central Science.
I'll help you with teaching topics.
1) Stoichiometry
2) Solution Chemistry
3) Chemical Kinetics
4) Chemical Equilibrium
5) Electrochemistry
6) Thermochemistry
7) Chemical Bonding
8) Chemistry of bicyclic compounds
9) Stereochemistry
10) Addition Reactions of Alkenes and Alkynes
11) Molecular Representations
12) Nucleophilic Substitution and Elimination reactions ( SN1, SN2, E1, E2, E1CB)
13) Synthesis and Mechanisms
14) Alcohols, phenols, ethers, and epoxides
15) Infrared and Mass Spectroscopy
16) NMR Spectroscopy (H-NMR, C-13-NMR)
17) Pericyclic Reaction
18) Aldehydes and ketones
19) Carboxylic Acids
20) Amine Chemistry
21) Carbohydrates Chemistry
0 Reviews
10+ Question Solved
Related Book For 
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Question Posted:
