THE TABLE IS NOT THE ANSWER TO THE QUESTION! IT IS THERE FOR HELP WRITING THE SQL QUERY. PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS.

1. Table: airbnb_search_details

a) Which city has the most expensive airbnb rental?

b) Which city has the least expensive airbnb rental?

c) Which city can accommodate the most people?

d) What is that number?

e) Does the property that can accommodate the most people also have the most number of bedrooms and beds?

CONTINUED TO THE RIGHT OF THE TABLE

ARENNW-WM- NULL NULL id price property_type room_type amenities accommodates bathrooms bed_type cancellation_poli... cleaning_fee city 12513361 555.68 |Apartment Entire home/apt |{TV,"Wireless Internet","Air conditioning","Smok... 12 1 Real Bed flexible False NYC 7196412 366.36 Cabin Private room |{"Wireless Internet", Kitchen, Washer,Dryer,"Smo... 2 3 Real Bed moderate False LA 16333776 482.83 House Private room {TV,"Cable TV", Internet,"Wireless Internet",Kitch... 2 1 Real Bed strict True SF 448.86 Apartment 1786412 Private room |{"Wireless Internet","Air conditioning",Kitchen, H... 2 1 Real Bed strict True NYC 14575777 506.89 Villa Private room {TV, Internet, "Wireless Internet", "Air conditioning... 6 2 Real Bed strict True LA Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet", Kitch... 8 20515889 720.79 Villa 3 Real Bed strict True LA Private room 13783491 516.48 Villa {TV,"Cable TV", Internet,"Wireless Internet","Air... 2 1 Real Bed strict True LA 6591755 529.33 Villa Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet",Kitch... 16 3 Real Bed strict True LA 5203241 679.68 Villa Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet","Air... 6 2 Real Bed strict True LA 11508891 633.51 Villa 2 LA Entire home/apt {TV, Internet, "Wireless Internet",Kitchen,"Free p... 10 Real Bed strict True 18823930 485.98 Villa 1 True Entire home/apt {TV, Internet, "Wireless Internet", Kitchen,"Free p... 16 Real Bed moderate LA 15523281 598.9 Villa Entire home/apt TV,"Cable TV", Internet, "Wireless Internet",Pool... 4 1 Real Bed strict True LA 19698509 741.76 Villa Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet","Air... 8 4 Real Bed super_strict_60 True LA 12497464 431.75 Apartment Private room {"Wireless Internet", Kitchen,"Buzzer/wireless int... 2 1 Real Bed moderate True NYC 17764793 469.13 Villa Private room |{TV,"Cable TV", Internet,"Wireless Internet","Air... 2 1 Real Bed moderate True LA Villa 11136854 485.2 1 True Entire home/apt {TV, Internet, "Wireless Internet","Air conditioning... 6 Real Bed strict LA 15754561 482.83 Apartment Entire home/apt {"Wireless Internet","Air conditioning",Kitchen,"F... 4 1 Real Bed moderate True NYC 4471474 313.55 House Shared room + 1 1 Real Bed flexible True LA 13207484 368.89 House Shared room |{TV,"Cable TV", Internet,"Wireless Internet","Air... 14 1 Couch strict True LA 7837072 336.73 House Private room |{Internet, "Wireless Internet","Air conditioning",Ki... 2 1 LA Real Bed moderate False 7823396 417.44 House Private room TV,"Cable TV", "Wireless Internet","Air condition... 2 1 True Real Bed moderate NYC 423.41 House 7966742 Private room {Internet, "Wireless Internet", "Air conditioning",Ki... 2 1 Real Bed strict True NYC 257568 389.18 House Private room {TV, Internet, "Wireless Internet","Air conditioning... 3 1 Real Bed strict True NYC 18073864 482.83 Apartment 2 Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet","Air... 4 Real Bed flexible True LA 13667633 541.61 House Entire homelapt {TV,"Cable TV", Internet,"Wireless Internet",Kitch... 5 2 Real Bed flexible LA True 662.01 House 590903 6 Entire home/apt {TV,"Cable TV", Internet, "Wireless Internet", "Air... 2 True Real Bed moderate LA 19161964 391.2 House Private room |{Internet, "Wireless Internet","Air conditioning","F... 1 1 Real Bed flexible True LA 19475815 470.05 House Private room {TV, Internet, "Wireless Internet","Air conditioning... 2 1 Real Bed moderate True NYC 1407841 412.71 House Private room {TV,"Wireless Internet","Air conditioning",Kitche... 2 1 Real Bed moderate True LA 1535628 407.75 House Private room {"Wireless Internet",Kitchen,"Pets live on this pr... 2 2 Real Bed moderate True NYC host_identity_verifi... host_response_rate host_since neighbourhood It 89% 11-18-2015 East Harlem f 100% 09-10-2016 Valley Glen t 100% 12-26-2013 Richmond District t 93% 05-11-2010 Williamsburg t 70% 10-22-2015 NULL f 20% 05-26-2014 Topanga t 90% 08-20-2015 Hollywood Hills t 91% 01-16-2016 Long Beach t 100% 08-17-2017 Rancho Palos Verdes t 94% 08-12-2015 Malibu t 90% 12-06-2013 Harbor Gateway If 100% 05-20-2014 t 100% 01-05-2015 t NULL 01-14-2014 Crown Heights t 100% 11-02-2012 Topanga t 100% 08-12-2014 Temple City f 100% 06-07-2017 Bedford-Stuyvesant t 100% 12-20-2013 t 25% 12-05-2016 Hollywood f 98% 07-02-2017 NULL f 100% 05-27-2015 Richmond Hill t 100% 06-27-2012 Bedford-Stuyvesant t 100% 04-20-2013 Astoria t 100% 09-27-2012 NULL t 100% 05-08-2015 Westchester/Playa... t 100% 03-01-2015 Mid-Wilshire f NULL 07-14-2016 NULL t 60% 11-14-2015 Astoria t 100% 05-27-2016 Mar Vista f 100% 03-10-2016 Hunts Point NULL number_of_reviews review_scores_rati... zipcode bedrooms beds 3 0 1 1 14 117 87 91 96 86 100 1 18 1 1 1 1 3 3 1 3 2 0 NULL 1 4 2 88 1. 43 27 100 90 100 92 93 88 4 1 6 14 2 2 2 4 NN 5 1 NULL 4 1 0 2 6 28 80 100 96 1 10029 91606 94118 11211 90703 90265 90046 90803 90275 90265 90501 90704 90277 11238 91364 91780 11216 91405 90028 91770 11419 11221 11106 91302 90045 90048 90650 11106 90066 10474 11231 1 1 2 1 0 NULL 0 NULL 1 4 1 1 1 1 1 0 NULL 1 NULL 1 0 174 1 1 1 1 2 2 1 96 89 90 90 94 100 18 246 10 8 2 0 4 18 2 2 3 3 NULL 1 1 1 1 93 99 100 83 1 1 1 1 4 1 8 1 Hoa n lo