Improving Decision Making: Using a Database to Clarify Business Strategy

Ess13ch03_questionfile.mdb

Home >Information Systems homework help > Improving Decision Making: Using a Database to Clarify Business Strategy

ID	Guest First Name	Guest Last Name	Room	Room Type	Arrival Date	Departure Date	No of Guests	Daily Rate
1	Barry	Lloyd	Hayes	Bay-window	12/1/17	12/4/17	2	¤ 150.00
2	Michael	Lunsford	Cleveland	Ocean	12/1/17	12/9/17	3	¤ 112.50
3	Kim	Kyuong	Coolidge	Bay-window	12/4/17	12/7/17	1	¤ 150.00
4	Edward	Holt	Washington	Ocean	12/1/17	12/3/17	4	¤ 325.00
5	Thomas	Collins	Lincoln	Ocean	12/9/17	12/13/17	2	¤ 300.00
6	Paul	Bodkin	Coolidge	Bay-window	12/1/17	12/3/17	2	¤ 150.00
7	Randall	Battenburg	Washington	Ocean	12/4/17	12/12/17	2	¤ 292.50
8	Calvin	Nowotney	Lincoln	Ocean	12/2/17	12/4/17	1	¤ 300.00
9	Homer	Gonzalez	Lincoln	Ocean	12/5/17	12/7/17	5	¤ 320.00
10	David	Sanchez	Jefferson	Bay-window	12/5/17	12/7/17	2	¤ 175.00
11	Buster	Whisler	Jackson	Ocean	12/5/17	12/8/17	2	¤ 250.00
12	Julia	Martines	Reagan	Bay-window	12/10/17	12/15/17	1	¤ 150.00
13	Samuel	Kim	Truman	Side	12/20/17	12/30/17	3	¤ 112.50
14	Arthur	Gottfried	Garfield	Side	12/13/17	12/15/17	2	¤ 125.00
15	Darlene	Shore	Arthur	Ocean	12/24/17	12/31/17	5	¤ 198.00
16	Carlyle	Charleston	Quincy Adams	Bay-window	12/3/17	12/6/17	2	¤ 150.00
17	Albert	Goldstone	Johnson	Ocean	12/5/17	12/7/17	3	¤ 250.00
18	Charlene	Tilson	Van Buren	Bay-window	12/5/17	12/7/17	1	¤ 150.00
19	Everett	Chad	Madison	Ocean	12/10/17	12/14/17	2	¤ 275.00
20	Gerald	Pittsfield	Roosevelt	Ocean	12/5/17	12/7/17	2	¤ 275.00
21	Jamal	Smith	Tyler	Bay-window	12/20/17	12/23/17	2	¤ 150.00
22	Louis	Paris	Jackson	Ocean	12/10/17	12/14/17	1	¤ 250.00
23	Nigel	Stratford	Eisenhower	Ocean	12/14/17	12/16/17	2	¤ 200.00
24	Peter	Willington	Grant	Ocean	12/19/17	12/21/17	1	¤ 200.00
25	Ronald	Cartier	Jefferson	Bay-window	12/24/17	12/28/17	4	¤ 175.00
26	Trista	Leven	Eisenhower	Ocean	12/17/17	12/20/17	1	¤ 200.00
27	Valerie	Snell	Adams	Bay-window	12/3/17	12/6/17	1	¤ 150.00
28	Walter	Acton	Polk	Side	12/24/17	12/31/17	6	¤ 148.50
29	Xavier	Trezza	McKinley	Side	12/14/17	12/17/17	2	¤ 125.00
30	Zachary	Miller	Washington	Ocean	12/13/17	12/16/17	2	¤ 325.00

SELECT [Reservations].[Room Type], Avg([Departure Date]-[Arrival Date]) AS [Avg Visit Length] FROM Reservations GROUP BY [Reservations].[Room Type];