THE TABLE IS NOT THE ANSWER TO THE QUESTION! PLEASE WRITE OUT THE SQL QUERY TO THESE QUESTIONS BASED ON WHAT YOU SEE FROM THE TABLE.

1. Table: Hotel_reviews

a) Find the countries with the most negative reviews. Output the country along with the number of negative reviews and sort records based on the number of negative reviews in descending order. You can ignore countries with no negative reviews.

The table below is from left to right:

CONTINUED

CONTINUED

hotel_address additional_number_of_scoring review_date average_score hotel_name 359 7/5/17 8.5 Novotel London Excel 7 Western Gateway Royal Victoria Dock Newham London E16 1AA United Kingdom 35 Charles Street Mayfair Westminster Borough London W1J 5EB United Kingdom 252 8/29/15 9.1 The Chesterfield Mayfair 14 Rue Stanislas 6th arr 75006 Paris France 40 5/23/17 9.1 Hotel Le Six reviewer_nationality negative_review United Kingdom coffee and tea at breakfast were not particularly hot Otherwise everything else was fine Israel No Negative United States of America There is currently utility construction taking place on the street in front of the hotel so a United Kingdom Coffee at breakfast could be better When you spend this amount in a hotel I expect bett United Kingdom A bit out of the way location wise United Kingdom No pool United Kingdom Couldn t fault anything about this hotel Gran V a De Les Corts Catalanes 570 Eixample 08011 Barcelona Spain 325 8/25/16 8.2 Sunotel Central Rathausstra e 17 01 Innere Stadt 1010 Vienna Austria 195 9/17/15 8.5 Austria Trend Hotel Rathauspark Wien 100 110 Euston Road Camden London NW1 2AJ United Kingdom 728 2/28/16 8.9 Pullman London St Pancras 12 Folgate Street City of London London E1 6BX United Kingdom 197 11/28/16 9.4 Batty Langley s 252 High Holborn Holborn Camden London WC1V 7EN United Kingdom 256 1/13/17 9.4 Rosewood London Australia Nothing 106 10/1/16 8.2 ARCOTEL Wimberger Iran It had not electric kettle Neubaug rtel 34 36 07 Neubau 1070 Vienna Austria 372 Strand Westminster Borough London WC2R OJJ United Kingdom 2288 8/30/16 8.1 Strand Palace Hotel Via Lucio Giunio Columella 36 Distretto Viale Monza 20128 Milan Italy 228 8/24/16 8.3 Hilton Garden Inn Milan North 384 12/10/16 9.2 Hotel Berna United Kingdom Room didnt have aircon United Kingdom Same breakfast daily United Kingdom The noise from other rooms and the hallway was rather noticeable United Kingdom cleaning staff took no notice of do not disturb signe on door and twice attempted to ent France Toilet didn t flush properly Room a bit noisy could hear the train annoucements from nea United States of America Noise 757 4/26/17 8.7 WestCord Fashion Hotel Amsterdam 838 9/22/15 8.4 The Grosvenor 1190 10/8/15 7.5 The Cumberland A Guoman Hotel 283 12/8/16 8.7 LaGare Hotel Milano Centrale MGallery by Sofitel Singapore Staff is just so so but not too bad 587 7/24/16 7.4 Best Western Blue Tower Hotel Kuwait The AC was not working They promised me to it but they did that the next day My ch 278 3/12/17 8.4 Dikker en Thijs Fenice Hotel United Kingdom No Negative Via Napo Torriani 18 Central Station 20124 Milan Italy Hendrikje Stoffelstraat 1 Slotervaart 1058 GC Amsterdam Netherlands 101 Buckingham Palace Road Westminster Borough London SW1W OSJ United Kingdom Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom Via Gian Battista Pirelli 20 Central Station 20124 Milan Italy Leeuwendalersweg 21 Bos en Lommer 1055 JE Amsterdam Netherlands Prinsengracht 444 Amsterdam City Center 1017 KE Amsterdam Netherlands 41 54 Buckingham Gate Westminster Borough London SW1E 6AF United Kingdom Wrights Lane Kensington and Chelsea London W8 5SP United Kingdom One Ham Yard Westminster Borough London W1D 7DT United Kingdom Spuistraat 288 292 Amsterdam City Center 1012 VX Amsterdam Netherlands 60 Hyde Park gate Kensington and Chelsea London SW7 5BB United Kingdom Eerste Constantijn huygensstraat 26G Oud West 1054 BR Amsterdam Netherlands 163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom 1299 11/30/16 8.7 St James Court A Taj Hotel London United Kingdom Initially we were over run with staff x three asking if we were comfortable dinner once se Would have been better if everthing wasn t extra surcharge to use the pool surchaege fo 1172 1/16/16 7.8 Holiday Inn London Kensington United Kingdom United Kingdom 96 2/4/16 9.5 Ham Yard Hotel 407 7/31/17 8.2 NH City Centre Amsterdam India No Negative Be careful about the superior view facing rooms being advertised They are very small w No Negative 72 1/30/16 9 Baglioni Hotel London The Leading Hotels of the World Switzerland Amadi Park Hotel United Kingdom 272 4/2/16 8.1 the breakfast could be better with more choices 2682 3/14/17 7.1 Britannia International Hotel Canary Wharf United Kingdom Everything was good review_total_positive_word_counts 34 review_total_negative_word_counts total_number_of_reviews positive review 16 1158 we were allocated the newly refurbished rooms and so everything was fresh and the bed was very comfortable the hotel is ideally situated near City Airport although eventually we travelled by train 0 1166 We liked everything The hotel is simply a boutique the staff were all polite and helpfull The room was clean and been serviced daily Wifi was completely free Breakfast was simply great I so much want to get back 27 177 Neat boutique hotel Some of the most comfortable hotel beds I have ever come across Staff was wonderful Loved the location Not too touristy Luxembourg gardens close by and a great place for a morning run walk 22 3870 Great bed nice to have a coffee machine in the room love the air conditioning and basically loved the attitude of the staff Really great 41 39 26 9 1884 Clean modern rooms and bathroom well equipped 9 3 3168 Breakfast 2 9 644 Plush luxurious room with excellent friendly staff 9 2 1008 Best bat in London 5 7 7 1886 Good location good stuff good breakfast 9568 No Positive 5 0 3613 Comfortable bed 3 13 4017 I loved the wonderful service I received here the room was very comfortable with a lovely big bath and a rubber duckie The staff were very helpful and friendly The hotel is very close to the main train station and there was no 55 22 5236 No Positive 0 18 3274 No Positive 0 2 5180 Location 2 10 2678 Everything is nice 5 32 3869 No Positive 0 o 1971 Excellent location Great breakfast lots of choice Room large comfortable with great view Helpful friendly staff Tram right outside Couldn t have got a better hotel Good value too 31 102 5394 No Positive 0 29 20 5945 Already recommended the hotel to friends going to London soon Great base oppulent feel without the price tag 314 Staff and the Honesty Bar 0 7 49 10 3417 Nice Restaurant with good breakfast spread Nice Location 290 Very friendly staff Rooms clean but not exactly sunlit Comfortably situated near Kensington Gardens It takes a ten minute walk to the next tube station Probably not quite a five star hotel but perhaps the most relaxed and we 0 44 days_since_review lat Ing total_number_of_reviews_reviewer_has_given reviewer_score tags 51.5077198 0.0229805 2 10 [' Leisure trip', 'Family with young children', 'Standard Double Room with Two Single Beds ','Stayed 2 nights', 'Submitted from a mobile device'] 29 days 705 day 51.5076899 -0.1471358 8 10 [' Leisure trip', 'Couple', 'Classic Double Room', 'Stayed 4 nights ', ' Submitted from a mobile device '] 72 days 48.8438352 2.3280708 3 9.2 [ Leisure trip','Family with young children', 'Deluxe Double Room ',' Stayed 4 nights ',' Submitted from a mobile device '] 343 day 41.3841429 2.1616896 2 9.2 [' Leisure trip', 'Group','Comfort Double or Twin Room', 'Stayed 1 night',' Submitted from a mobile device '] 686 day 48.2133054 16.3567884 2 7.5 [' Leisure trip','Couple','Comfort Room ','Stayed 2 nights ','Submitted from a mobile device '] 522 day 51.5286766 -0.1283489 1 8.8 [' Business trip', 'Solo traveler', 'Classic King Room ',' Stayed 1 night', 'Submitted from a mobile device 'l 248 day 51.5208575 -0.0779503 2 10 [' Leisure trip',' Couple ',' Superior Double Room ',' Stayed 1 night','Submitted from a mobile device '] 202 day 51.5173303 -0.1180966 1 9.6 [' Leisure trip','Family with young children', 'Executive King Room ','Stayed 5 nights ',' Submitted from a mobile device '] 306 day 48.2006001 16.3386333 14 7.5 [' Leisure trip', 'Group','Comfort Double Room', 'Stayed 2 nights',' Submitted from a mobile device '] 338 day 51.5110993 -0.1208673 3 8.8 [' Leisure trip', 'Group','Cosy Double Room', 'Stayed 1 night','Submitted from a mobile device'] 344 day 45.5161671 9.2272778 5 7.1 [' Leisure trip', 'Solo traveler', 'King Room ','Stayed 2 nights ','Submitted from a mobile device '] 236 day 45.4826692 9.2034371 23 9.6 [' Leisure trip', 'Solo traveler', 'Superior Single Room', 'Stayed 4 nights '] 99 days 52.357655 4.844576 6 7.9 [' Solo traveler', 'Large Double Room', 'Stayed 4 nights '] 681 day 51.4956657 -0.1452793 1 6.3 [' Leisure trip ',' Couple ',' Standard Double Room ','Stayed 3 nights',' Submitted from a mobile device') 665 day 51.514879 -0.1606501 21 7.5 [' Business trip', 'Solo traveler', 'Standard Single Room', 'Stayed 3 nights', 'Submitted from a mobile device '] 238 day 45.484237 9.198858 10 9.2 [' Leisure trip ',' Couple ',' Superior Twin Room', 'Stayed 2 nights','Submitted from a mobile device 'l 375 day 52.3793659 4.8457179 20 4.6 [' Leisure trip', 'Family with young children ','Standard Quadruple Room ','Stayed 2 nights '] 144 day 52.364971 4.8839827 4 9.6 [' Leisure trip ',' Couple ',' Superior Room with canal view ','Stayed 3 nights', 'Submitted from a mobile device '] 246 day 51.4986732 -0.1376867 1 7.1 [' Family with young children', 'Classic Twin Room ','Stayed 1 night '] 565 day 51.499981 -0.1928791 2 10 [' Business trip ',' Couple ',' Superior Double Room ','Stayed 2 nights ',' Submitted from a mobile device 'l 546 day 51.511174 -0.1349904 5 10 [ Leisure trip ',' Couple ',' Superior Room ','Stayed 1 night',' Submitted from a mobile device ') 3 days 52.3697554 4.8887815 6 6.3 [' Leisure trip', 'Family with young children', 'Superior Double or Twin Room with View ','Stayed 3 nights '] 551 day 51.5017224 -0.1846243 28 8.8 [' Leisure trip ',' Couple ', ' Deluxe Double Room ','Stayed 4 nights ',' Submitted from a mobile device 'l