SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE airbnb (`id` int, `name` varchar(51), `host_id` int, `host_name` varchar(14), `borough` varchar(13), `district` varchar(25), `room_type` varchar(15), `price` int, `minimum_nights` int, `number_of_reviews` int, `last_review` date, `reviews_per_month` int) ; INSERT INTO airbnb (`id`, `name`, `host_id`, `host_name`, `borough`, `district`, `room_type`, `price`, `minimum_nights`, `number_of_reviews`, `last_review`, `reviews_per_month`) VALUES (16416474, 'Sun Drenched Spacious Loft in NYCs Trendiest Hood', 6755652, 'Jenny', 'Manhattan', 'Lower East Side', 'Entire home/apt', 205, 3, 102, '2019-06-23', 3.36), (25832499, 'summer downtown W/ TERRACE', 2412677, 'Jenny', 'Manhattan', 'Chinatown', 'Private room', 100, 2, 1, '2018-06-17', 0.08), (9414019, 'Yogi''s Luxury on Prospect Park', 1333485, 'Jenny', 'Brooklyn', 'Windsor Terrace', 'Entire home/apt', 200, 2, 19, '2017-01-02', 0.45), (4402805, 'LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK', 22807362, 'Jenny', 'Brooklyn', 'Prospect-Lefferts Gardens', 'Entire home/apt', 120, 3, 3, '2018-08-28', 0.05), (15374796, 'Large UWS Apt close to Central Park', 7610841, 'Jenny', 'Manhattan', 'Upper West Side', 'Private room', 115, 2, 72, '2019-05-19', 2.55), (1677887, 'Charming LG Bedroom by Park & Train', 8756595, 'Jenny', 'Brooklyn', 'Prospect-Lefferts Gardens', 'Private room', 80, 31, 28, '2016-07-12', 0.4), (32379480, 'Celebrity Central Park townhouse designer''s touch.', 243132541, 'Jenny', 'Manhattan', 'Upper East Side', 'Entire home/apt', 1497, 1, 10, '2019-06-30', 2.36), (33303647, 'Rento cómoda habitación para pareja oh persona sol', 250841016, 'Jenny', 'Bronx', 'Norwood', 'Private room', 58, 5, 0, NULL, NULL), (22034977, 'South Bronx Hideaway', 148100571, 'Jenny', 'Bronx', 'Soundview', 'Entire home/apt', 50, 1, 2, '2017-12-09', 0.1), (27508376, 'Modern Luxury Condo in the UES with Fitness Center', 2093069, 'Jennyfer', 'Manhattan', 'East Harlem', 'Entire home/apt', 106, 2, 8, '2019-06-10', 1.53), (2098817, 'Historic Townhouse 3bed 2bath * 1 block to subway', 2462590, 'Jenny And Mark', 'Brooklyn', 'Bushwick', 'Entire home/apt', 350, 2, 6, '2019-05-01', 0.95), (31435994, 'Cozy Bedroom Uptown Manhattan', 47515751, 'Jennyfer', 'Manhattan', 'Inwood', 'Private room', 40, 4, 1, '2019-03-05', 0.24), (11334476, 'Comfortable Bedroom', 47515751, 'Jennyfer', 'Manhattan', 'Inwood', 'Private room', 35, 3, 10, '2019-03-24', 0.24), (3928833, 'Brooklyn townhouse for filming', 1331180, 'Matt -N- Jenny', 'Brooklyn', 'Bushwick', 'Entire home/apt', 1000, 2, 0, NULL, NULL), (20710208, 'Brooklyn Garden Guesthouse *1 block to subway*', 2462590, 'Jenny And Mark', 'Brooklyn', 'Bushwick', 'Entire home/apt', 175, 1, 47, '2019-06-18', 2.2), (35003154, 'Beautiful Brooklyn Vacation Home!', 3371859, 'Jenny & Jose', 'Brooklyn', 'Crown Heights', 'Entire home/apt', 88, 2, 4, '2019-06-30', 3.53), (764753, 'Beautiful 3 bedroom apartment!!', 3371859, 'Jenny & Jose', 'Brooklyn', 'Crown Heights', 'Entire home/apt', 82, 8, 108, '2019-06-16', 1.33), (23108435, 'A very spacious Zen place to vacay.', 146172048, 'Jennyfer', 'Queens', 'Woodside', 'Private room', 49, 4, 5, '2019-01-03', 0.36), (22832352, '*PRIME* Serenity & Love-Private Oasis (Bedford Av)', 168784638, 'Ralph & Jenny', 'Brooklyn', 'Williamsburg', 'Entire home/apt', 237, 3, 28, '2019-06-03', 2.09), (35970385, 'Williamsburg Domino Park Prime Location 2 bedroom', 11612418, 'Yulia', 'Brooklyn', 'Williamsburg', 'Entire home/apt', 285, 7, 0, NULL, NULL), (20729216, 'Whole Apt/Private Entry/Free Parking', 148444929, 'Karl', 'Staten Island', 'St. George', 'Entire home/apt', 109, 2, 87, '2019-07-06', 5.08), (22242334, 'Whole Apartment Near Prospect Park', 41423658, 'Diane', 'Brooklyn', 'Prospect-Lefferts Gardens', 'Entire home/apt', 69, 2, 37, '2019-06-11', 2), (14835065, 'West Village Apartment near Washington Square Park', 77722758, 'Robert', 'Manhattan', 'Greenwich Village', 'Entire home/apt', 200, 1, 4, '2017-12-30', 0.12), (21139541, 'Tidy Cozy Room separate entrance paid parking', 120767920, 'Jimmy &Cindy', 'Queens', 'Flushing', 'Private room', 43, 2, 43, '2019-05-27', 1.99), (23766156, 'TheBlueHouse. EntireHome. BabyGrand. FreeParking.', 178266385, 'Megan', 'Brooklyn', 'Cypress Hills', 'Entire home/apt', 800, 1, 3, '2018-08-15', 0.21), (34384645, 'The BEAUTY & the EAST/free street parking & WIFI', 219738858, 'Joe', 'Manhattan', 'East Village', 'Entire home/apt', 120, 365, 4, '2019-05-17', 1.9), (35468870, 'Sunny. Free Parking available on street.', 266860944, 'Rohon', 'Queens', 'Rosedale', 'Private room', 44, 7, 1, '2019-06-30', 1), (32474739, 'Sunny Modern Lux Private House with Parking', 12593328, 'Jeromy', 'Brooklyn', 'East Flatbush', 'Entire home/apt', 74, 3, 11, '2019-06-14', 2.84), (30158743, 'Stay in Lovely 2 BR/1 BA Flatbush Apartment', 95114505, 'Aiesha & Stacy', 'Brooklyn', 'East Flatbush', 'Entire home/apt', 150, 3, 3, '2019-06-30', 3), (23076745, 'Convenient! Private Room 10 mins to JFK Airport', 131476068, 'Leslie', 'Queens', 'Richmond Hill', 'Private room', 75, 2, 1, '2018-02-09', 0.06), (32467835, 'SPACIOUS & COMFY 3 BDROM/2 BATH APT CLOSE 2 SUBWAY', 216419980, 'Billie', 'Manhattan', 'Harlem', 'Entire home/apt', 112, 30, 0, NULL, NULL), (2415563, 'The Big Brooklyn', 12346795, 'Ron', 'Brooklyn', 'Crown Heights', 'Private room', 60, 1, 35, '2018-04-24', 0.54), (30888271, 'Cozy Cypress Suite Convenient To Train & JFK ×', 230801598, 'JuVita', 'Brooklyn', 'Cypress Hills', 'Private room', 80, 1, 10, '2019-06-19', 1.51), (15987959, 'Cozy apartment in Upper East!', 4122796, 'Sebastien', 'Manhattan', 'Upper East Side', 'Entire home/apt', 129, 2, 1, '2016-11-18', 0.03), (3473305, 'One bedroom apartment', 16718001, 'Nicholas', 'Brooklyn', 'Bedford-Stuyvesant', 'Entire home/apt', 50, 3, 15, '2016-06-21', 0.25), (21016498, 'Newly Renovated Apartment', 51716739, 'Harvin', 'Brooklyn', 'Bedford-Stuyvesant', 'Entire home/apt', 180, 2, 13, '2019-06-30', 0.73), (34935477, 'Private Oasis in the heart of the East Village', 65814872, 'Parisa', 'Manhattan', 'East Village', 'Entire home/apt', 250, 30, 0, NULL, NULL), (21201088, 'Luxury designer duplex in Bed Stuy', 761943, 'Chris', 'Brooklyn', 'Bedford-Stuyvesant', 'Entire home/apt', 225, 3, 12, '2019-07-02', 0.61), (4611295, 'Upper East Side Manhattan #2', 626876, 'Kimberly', 'Manhattan', 'Upper East Side', 'Private room', 250, 1, 0, NULL, NULL), (18306444, 'Lively SoHo/Quiet St/2 blocks Subway/Fast WiFi', 114548258, 'Only One', 'Manhattan', 'SoHo', 'Entire home/apt', 215, 1, 83, '2019-06-25', 3.19), (13896200, 'HUGE New Industrial Williamsburg Apartment', 6000480, 'Douglas', 'Brooklyn', 'Williamsburg', 'Entire home/apt', 220, 4, 4, '2017-10-31', 0.11), (19019325, 'HUGE ROOM WITH PRIVATE KITCHEN- Manhattan -', 132711675, 'Yifat', 'Manhattan', 'Murray Hill', 'Private room', 60, 10, 0, NULL, NULL), (34331687, 'Bayside Room', 252440873, 'Luisa', 'Queens', 'Bayside', 'Private room', 40, 31, 0, NULL, NULL), (27214615, '4BR 4 BATH IN THE HEART OF WEST VILLAGE', 200380610, 'Pranjal', 'Manhattan', 'West Village', 'Entire home/apt', 483, 30, 0, NULL, NULL) ; SELECT name, host_name, borough, district, price FROM airbnb WHERE name LIKE BINARY '%park%';