WRITE OUT SQL QUERY:

a) Whats the acceptance rate of requests?

b) What can airbnb do to increase the number of bookings?

The bold question at the bottom is an open-ended question. There is no right or wrong answer but youll be graded on your approach and the data-driven support you provide. To answer the question thoroughly, you should aim to analyze the data 3-4 different ways to provide support for your answer.

airbnb searches ds id_user ds_checkin ds_checkout n_searches n_nights n_guests_min n_guests_max origin_country filter_price_min filter_price_max filter_room_types filter_neighborhoods 2014-10-11 67aece73-e112-4e9e-9e05-8a2a94b003b9 NULL NULL 5 NULL 1 1 IT 0 99 Private room NULL 2014-10-01 6cbb33d1-6ecc-4f74-8b6a-a43d07d484b6 2014-10-04 2014-10-07 11 3 3 3 ES 0 567 Entire home/apt,Entire home/apt, Private room, Entire home/apt, Private room, Shared room NULL 2014-10-03 aa9cf5bf-5667-4212-8018-1cb8beee530e 2014-11-14 2014-11-16 17 2 2 2 GB 0 171 ,Entire home/apt NULL 2014-10-09 3e6c2466-74fe-44c0-a6f3-dda79755d30a 2015-02-26 2015-03-02 9 4 1 4 GB 0 240 ,Entire home/apt NULL 2014-10-13 a09bf912-b21d-4859-b194-8512c30695f6 2014-10-18 2014-10-22 7 4 1 2 GB NULL NULL ,Entire home/apt NULL 2014-10-01 Of4ea370-702c-4f08-a00d-98e67c2a3574 2014-10-10 2014-10-12 16 2. 6 8 US o 345 Entire home/apt NULL 2014-10-08 b2fda 15a-89bb-4e6e-ae81-8b21598e2482 NULL NULL 4 NULL 1 2 FR 0 78 ,Private room NULL 2014-10-04 0f4ea370-702c-4f08-a00d-98e67c2a3574 2014-10-10 2014-10-13 25 3 3 8 US 0 200 Entire home/apt NULL 2014-10-05 b6a8b1f9-5b40-4edd-91f3-ee522b0f9e5b 2014-12-27 2015-01-03 24 7 1 4 FR 91 1073741823 Entire home/apt NULL 2014-10-05 86b39b70-965b-479d-a0b0-719b195acea2 2015-03-13 2015-03-18 4 5 5 5 IE NULL NULL Entire home/apt NULL 2014-10-06 a9f7ffb1-4970-492b-b448-4bd9d0fbeef3 2015-03-15 2015-03-18 6 3 2 5 AU 0 NULL 376 Entire home/apt Entire home/apt 2014-10-10 86b39b70-965b-479d-a0b0-719b195acea2 2014-10-23 2014-10-26 10 3 7 7 IE NULL NULL NULL 2014-10-04 fad1a097-a511-4844-a603-6a271c1f159e 2014-10-05 2014-10-06 11 1 1 2 IE 0 63 ,Private room, Entire home/apt NULL 2014-10-12 d328a4a0-df5f-4851-a864-a8845b45c1e0 2014-10-23 2014-10-29 No 6 1 1 DE O NULL 63 Private room 600 Entire home/apt 2014-10-06 eda96881-7b23-413a-9f6f-b45dc9fe2a5b 2015-06-12 2015-06-14 40 2 1 12 GB 0 NULL 2014-10-04 126ed661-fa20-4041-ac16-ec118bbcce3b NULL NULL 24 NULL 1 4 GB 18 NULL 1073741823 ,Entire home/apt, Private room, Shared room NULL ,Entire home/apt 2014-10-03 598f8459-96f6-4400-8bce-1474757dd589 2015-03-12 2015-03-19 16 7 1 2 TR NULL NULL airbnb contacts id_guest id_host id_listing ts_contact_at ts_reply_at ts_accepted_at ts_booking at ds_checkin ds_checkout n_guests n_messages 86b39b70-965b-479d-a0b0-719b195acea2 1dfb22ec-c20e-4bf9-b161-1607afa25c5a d668de42-122a-45cd-b91f-91a70895f902 2014-04-18 09:32:23 2014-04-18 09:39:06 NULL NULL 2014-12-31 2015-01-02 7 5 14f943bb-74e9-458b-be55-203dc7220688 3347390d-8670-4870-9dab-da30f3700141 14c47fb8-e831-4044-9674-9b3fd0499193 2014-10-06 06:55:45 2014-10-06 10:06:38 2014-10-06 10:06:38 2014-10-06 10:06:38 2014-11-03 2014-11-07 2 8 425aated-82ab-4ecf-b62f-d61e1848706d 02cafb86-5445-45cc-80f2-405291578356 c5a4a913-a094-4a9d-82e2-0b2d4f9d9eeb 2014-10-04 05:02:39 2014-10-04 23:10:01 NULL NULL 2014-11-02 2014-11-09 2 2 bb490ede-8a70-4d61-a2e8-625855a393e2 f49c3095-58de-4b8d-9d5b-3bfceceb47d8 27f4b429-d544-464f-b4b5-3c09fd5992e7 2014-08-31 11:46:11 2014-08-31 16:48:28 NULL NULL 2014-11-03 2014-11-07 2 5 b2fda15a-89bb-4e6e-ae81-8b21598e2482 71f1d49e-2ff4-4d72-b8e6-fd4c67feaa74 95fb78ca-8e6e-436a-9830-949d995ad14f 2014-10-08 15:07:56 2014-10-08 15:32:12 2014-10-08 15:32:12 2014-10-08 22:21:41 2014-11-06 2014-11-09 2 10 b8831610-31f2-4c58-8ada-63b3601ca476 bdd8a691-31e2-48d8-b526-6a75a4363b89 9633168d-9834-4887-af97-6af7db1d96ab 2014-10-14 04:05:14 2014-10-14 08:48:41 2014-10-14 08:48:41 NULL 2014-11-07 2014-11-29 2 17 136c10f8-af53-4e5a-a5b3-d9c9c495b166 6dc86890-53d7-4d06-b767-5e117762d76b 2e6adb00-a660-465e-a85e-c8e341a5fb2f 2014-12-06 20:24:54 2014-12-06 20:49:00 2014-12-06 20:51:56 2014-12-06 20:51:56 2014-12-12 2014-12-14 2 13 9a45a950-b4f7-4f16-abe6-f9286abf2641 beeab7c3-ab4e-45d7-bde9-978deOfd8d57 c318d3e3-b36e-43b8-9b0c-3400cbca3895 2014-10-11 21:15:30 2014-10-12 09:17:14 NULL NULL 2014-10-24 2014-10-27 1 3 1759c05e-f12a-4eaa-8059-3bcaca443c88 200a661e-2758-45e9-8bcc-42e32342e6bd e465ef3d-3c26-4c46-b515-4b24d10bcdf8 2014-10-31 12:40:58 2014-10-31 12:55:50 NULL NULL 2014-10-31 2014-11-02 2 3 126ed661-fa20-4041-ac16-ec118bbcce3b a33e4240-6a0c-47b4-b866-45f9b5952c18 2d77af55-7f10-41d6-93da-383cf59082b6 2014-10-03 12:02:49 2014-10-03 12:05:25 NULL NULL 2014-10-25 2014-10-29 4 2 924f864f-db83-4945-9a65-cf42a657ca68 7c0b097b-ea7c-4ea2-967a-8fe38fce6e95 f63e28a2-0f72-4b3e-8b5c-46284455ff9a 2014-10-21 20:57:44 2014-10-21 21:12:25 2014-10-23 21:04:47 NULL 2014-11-09 2014-11-15 3 4 bd8f3dd6-fecC-479a-a88f-1d0049600e9f d73772a8-efa3-445c-b9c2-0498fea9815f 5236a962-7989-4563-9086-b3c5e5af4dba 2014-10-09 07:46:25 2014-10-09 08:04:13 2014-10-09 08:04:13 2014-10-09 09:30:18 2014-10-10 2014-10-12 2 10