Introduction The purpose of this assignment is to practice developing queries you learned about in the narrated PowerPoi

[answerhappygod]

Introduction
The purpose of this assignment is to practice developing queries
you learned about in the narrated PowerPoint slides in the advanced
section of the SQL module on the database named IT3233HotelDB you
attached earlier in the course in SQL Server Management Studio
(SSMS) (please run all queries in this DB). This is a database for
a fictitious hotel chain called Eagle International Hotels. The
database has tables about customers, reservations, room types,
hotels and specials. The tables for this problem are show
below

Introduction The Purpose Of This Assignment Is To Practice Developing Queries You Learned About In The Narrated Powerpoi 1 (81.78 KiB) Viewed 26 times

You will be developing the queries for the problems
listed below. Remember to always start with SELECT *.
 Use the database provided on the server for this project. Copy
the folder provided and attach the database in SSMS.
1. List the confirmation number, customer's first and
last name, hotel's name, check-in-date, number of days the customer
is staying and the room type for all reservations and list the
results in order of the confirmation number.

Introduction The Purpose Of This Assignment Is To Practice Developing Queries You Learned About In The Narrated Powerpoi 2 (27.05 KiB) Viewed 26 times

2. What are the number of reservations for the Omni? RESULT:
4

Introduction The Purpose Of This Assignment Is To Practice Developing Queries You Learned About In The Narrated Powerpoi 3 (30.49 KiB) Viewed 26 times

4. List the name of the hotels that do not allow pets but do
have a fitness center.
RESULTS:
HotelName The Partridge Inn
Hampton Inn Statesboro
SpringHill Suites Statesboro University Area
Results Messages Custid LName FName Street Email LoyaltyNum 1 81032 SW 8th St. Zip Phone 30458 912-555-1327 [email protected] 19635 30458 912-555-1687 [email protected] 2 NULL 3 NULL 4 23995 Sanders 11260 5 15215 6 45665 7 63351 52268 State 15003 Russell Anne Statesboro GA 15521 Alder Cora 3103 Greene St. Statesboro GA 22632 Walters Frank 991 Washington Dr. Atlanta GA 48261 404-555-3623 [email protected] Patrick 748 Broad St. Augusta GA 30909 706-555-3200 [email protected] 37202 Carson Gregory 36654 Reynolds St. Augusta GA 30905 706-555-1002 augusta [email protected] 40025 Guthrie Benjamin 27 Hendrix Ave. Atlanta GA 51089 770-555-1530 [email protected] 43335 Butler Benjamin 38843 NE 3rd St. Atlanta GA 54483 770-555-6485 [email protected] 8 46002 Williams Brian Atlanta GA 56011 770-555-8066 [email protected] 9 48552 Franks Diana Statesboro GA 30458 912-555-6477 [email protected] NULL 10 49635 Johston Drake Atlanta GA Statesboro GA Augusta GA Atlanta GA Augusta GA Atlanta GA Augusta GA Augusta GA Statesboro GA Statesboro GA Augusta GA NULL 203 Butterfly Dr. 324 Birch St. 34 S West St. 409 Main St. 15479 Muffin Ln. 4456 Frier St. NULL 11 52274 Saunders 12 52694 Allen 54225 404-555-6321 [email protected] 30458 912-555-4025 [email protected] 30509 706-555-8824 [email protected] 56321 770-555-8225 [email protected] 16698 NULL 13 14 62230 Parks 11125 62552 Emily Harry 56885 Fitzgerald Nora Bella 15 64820 Reynolds Regina 16 78561 Williams Jan 17 82249 Adams 18 93364 Smith 19 96634 Grey 20 99644 Smith NULL 1337 Orange St. 407 Chocolate Ln. 753 McGruder Ln. Frederick 1010 Berkley St. Gregory 1468 Main St. Saman... 7331 Sunrise Ct. Candice 543 Mayberry Ln. 30907 706-555-3588 [email protected] 49602 404-555-6208 [email protected] 30905 706-555-4694 [email protected] 30906 706-555-5899 [email protected] 30458 912-555-6421 [email protected] 30458 912-555-1337 [email protected] 30554 706-555-4632 [email protected] NULL 78564 13375 NULL Customer table

Results Messages Custid Credit Card Num 1 15003 2034982039482031 2 15521 9764564358969813 3 22632 3409528304032948 4 23995 2837239801980401 5 37202 6870298235098630 6 40025 0293840509209374 7 43335 8940923095320423 8 46002 2309482034980120 9 48552 7829389723509091 10 49635 1208946098230698 11 52274 5365768797089022 52694 0899768958564652 12 13 56885 2309832096092098 14 62230 4092803298036861 15 64820 0489023908234096 16 78561 8923049820915709 17 82249 0960893093209460 18 93364 3098232098309852 19 96634 4290860934092309 20 99644 5980589289289589 CustomerCard table

100 % Results Hotelld 1 101 2 102 3 103 4 201 5 202 6 203 7 301 8 302 9 303 Resuts Hotelld 101 101 101 101 101 101 7 101 8 101 9 102 10 102 11 102 12 201 13 201 14 201 15 201 16 201 17 202 18 203 19 301 20 301 21 302 22 302 23 302 24 302 25 303 26 303 1 2 3 4 5 6 Messages Name Omni Hotel at CNN Center Hotel Midtown The Ellis Hotel The Partridge Inn Microtel Inn and Suites Wingate by Wyndham Hampton Inn Statesboro Holiday Inn Hotel Statesboro-University Area Spring Hill Suites Statesboro University Area Messages Amenity Express Checkout Fitness center Free Breakfast Free wireless On-site dining Pets Room Service Spa Express Checkout Free Breakfast Pets Fitness center Free Breakfast On-site dining Room Service Spa Free wireless Free Breakfast Fitness center Free wireless Express Checkout Fitness center Free wireless Pets Express Checkout Fitness center Street 100 CNN Center 125 10th Street Northeast 176 Peachtree Street Northwest 2110 Walton Way 2909 Riverwest Drive 2123 Noland Connector 616 Fair Rd. 455 Commerce Dr. 105 Springhill Drive Hotel table State Zp Phone City Atlanta Pelarta NumRooms GA 30303 404-555-0000 1070 GA 30309 404-555-4800 190 Atlanta GA 30303 404-555-7872 127 Augusta GA 30904 706-555-8888 144 Augusta GA 30907 706-555-8010 62 Augusta GA 30906 706-555-1616 64 Statesboro GA 30458 912-555-7700 80 Statesboro GA 30458 912-555-4545 93 Statesboro GA 30458 912-555-0000 113 HotelAmenity table Description Category Luxurious comfort embraces pure style at the eleg PL Hotel Midtown offers a premier location to experie BC Official site of The Blis Hotel. An extraordinary lux GD A hotel is first and foremost, lodging. And at The PL "The nearest fire door to my room was blocked a BC This property has everything the business traveler.... SL Get a dose of small town hospitality amidst big-ct... SL Ideally situated near the Statesboro Municipal Ar... GD Our suites are designed 25% larger so you will ha... PL

Results 1 101 2 101 3 102 4 102 5 103 6 201 201 202 202 10 203 11 203 12 301 13 302 14 303 Messages Special Name Spring Break St. Patrick's Day Spring Break St. Patrick's Day Spring Break Masters Week St. Patrick's Day Masters Week St. Patrick's Day Masters Week St. Patrick's Day Spring Break Spring Break Spring Break Results Messages Confirmation Num Hotelld 1 112233 103 101 2 112234 3 112235 101 4 112236 202 5 112237 202 6 153896 101 7 103 201155 302551 8 103 9 325525 101 10 203 303 11 12 544520 605204 704560 823002 933505 13 302 303 303 14 7 8 9 Hotelld Price Room Type NULL 110.00 Two Queen Beds 220.00 NULL 350.00 NULL 75.00 NULL 69.00 One King Bed 525.00 Two Queen Beds 150.00 NULL 155.00 One King Bed 475.00 Two Double Beds 100.00 NULL 125.00 Two Double Beds 115.00 Two Queen Beds 160.00 NULL 175.00 HotelSpecial table PriceSchedule table

1 2 3 4 1 112233 2 112234 3 112235 4 112236 112237 5 6 7 8 15309 201155 302551 5 325525 10 544520 11 563354 12 605204 13 704060 14 823002 SONS 15 1 2 13 Confitum Checke 1 2 2010-06-01 00:00:00 000 5 2010-04-20 00:00:00 000 4 2010-04-1700 00:00:00 2 2010-04 17-0000000001 2010-04-02 00:00:00 000 1 2010-04-20 00:00:00 000 3 2010-03-15 00:00:00.000 1 2010-04-17 00:00:00 000 2 2010-03-07 00 00 00 000 2 2010-04-1500 0000 000 1 2010-03-07 00:00:00 000 3 2010-03-2400-00-00 000 4 56885 2010-03-25 00:00:00 000 1 2010-03-16 00:00:00 000 2 2010-04-030000000005 39544 36634 Destion Baned per stay with card and 2 night Emad party with cant and night m Baned per say with card and Snight in Eame pay with cand and 3 right na Descrption A spacious room with one king bed a jocura ban Aspacious me with two double bed, a chair and t Acous room with two queen beds, a couch and Name Oecon Masters Week Sering k Reserve your are now and get a 1100 goed go. at Get 20% perpen you reserve 2o St. Packs Day Get 10% off your reserved stay for St. Pas Day ses Category Pied BC 50 150 00 PL 200 SL 100 Pack Messages Type One King Bed Two Double Beds Two Quem Bodo Fonds NuDay Cat 54820 52274 5227 15003 15003 15003 15521 33202 23995 04320 52274 46002 Vessages Stat 2010-04-05 00:00:00.000 2010-03-15 00-00-00 000 2010-03-16 00:00:00 000 Reservation table Rewards table Room Type table EndDate 2010-04-13 00:00:00 000 2010-03-190000-00000 2010-03-18 00:00:00 000 Special table

RESULTS: Confirm... fname Iname 112233 Regina Reynolds 112234 Emily Saunders 112235 Emily Saunders 112236 Anne Russell name checkindate numdays 2010-05-01 The Ellis Hotel 5 2010-04-20 4 Omni Hotel... Omni Hotel... 2010-04-17 2 Microtel Inn a... 2010-04-17 1 roomtype NULL Two Queen Beds NULL NULL

3. For each hotel list the number of reservations (even if there are no reservations). RESULTS: HotelName NumReservations Hampton Inn Statesboro 0 Holiday Inn Hotel Statesboro-University Area 1 Hotel Midtown 0 Microtel Inn and Suites 2 Omni Hotel at CNN Center Spring Hill Suites Statesboro University Area 3 WAN 4