Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a SQL statement to display listing names and property types of all the listings. Write a SQL statement to display the distinct property types
- Write a SQL statement to display listing names and property types of all the listings.
- Write a SQL statement to display the distinct property types of all the listings.
- Write a SQL statement to display the name, price, and city for Apartment type of listings.
- Write a SQL statement to display the name, price, city, and neighbourhood for Apartment, House and Cabin type of listings.
- Write a SQL statement to display the name, price, and property type of listings that offer accommodation in a range of 2 to 5.
Listings Table contains information of some listings (i.e., properties) listed on airbnb.com website; (Fields: listing_id, listing_url, name (i.e., names of listings), host_id, host_name, host_response_time, neighbourhood, neighbourhood_group, city, state, property_type, accommodates, beds (i.e., the number of beds), price, number_of_reviews, review_scores_rating, cancellation_policy),
Reviews Table contains the reviews given to different listings listed in the Listing Table. (Fields: listing_id, id, date, reviewer_id, reviewer_name, comments)
- El listings reviews X listing url name + https://www.airbnb.com/1 Sweet Seattle Urban Homestead + https://www.airbnb.com/1 Sunrise in Seattle Master Suit + https://www.airbnb.com/1Cozy Studio, min. to downtown + https://www.airbnb.com/1 Fab, private seattle urban cot https://www.airbnb.com/1 launchingpad/landingpad + https://www.airbnb.com/1 Golden Sun vintage warm/sunny + https://www.airbnb.com/1 Downtown Convention Ctr B&B + https://www.airbnb.com/1 The Adorable Sweet Orange Craf + https://www.airbnb.com/1 The Coolest Tangerine Dream MI https://www.airbnb.com/1 the down home central and fah + https://www.airbnb.com/1Upscale Seattle Hotel Alternat + https://www.airbnb.com/1 Private 2 Rooms & 1 Bath + https://www.airbnb.com/1 the orange house, quiet 'n cen + https://www.airbnb.com/1 Hotel Room & Bath Alternative + https://www.airbnb.com/1 THE URBAN OASIS- Great Locatic + https://www.airbnb.com/1 Quiet Cozy Upstairs BR Green I + https://www.airbnb.com/1 Green Lake Private Ground Floc + https://www.airbnb.com/1 West Seattle, The Starlight St + https://www.airbnb.com/11 Bedroom Downtown Seattle Oas https://www.airbnb.com/11 Bedroom Cosmopolitan Water V https://www.airbnb.com/12 Bedroom Downtown Seattle Oas + https://www.airbnb.com/12 BR Spacious Mother-in-Law Cc https://www.airbnb.com/1 Cottage in the Heart of Ballar + https://www.airbnb.com/1 Victorian in the Heart of Ball + https://www.airbnb.com/1 Harrison Modern "Mad Men Suit https://www.airbnb.com/13bd 2bt great bargain sleep 6 https://www.airbnb.com/11 Bedroom Modern Water View Cc + https://www.airbnb.com/1Luxury Treehouse Garden Cottag + https://www.airbnb.com/12 Bedroom Water View Oasis https://www.airbnb.com/1 Beautiful, Quiet, Friendly Bal https://www.airbnb.com/1 Adult Only Quiet 2/br Capitol https://www.airbnb.com/1 Cozy Ballard Apartment + https://www.airbnb.com/1 Ballard: Walk to Salt Water Be https://www.airbnb.com/13br, modern, fire place, chef ki #https://www.airbnb.com/1 Home Away From Home - MIL Suit # https://www.airbnb.com/Big sunny central house with v +https://www.airbnb.com/1Cottage in West Seattle Gues + https://www.airbnb.com/1Capitol Hill Suite + Free Park https://www.airbnb.com/1 Tranquil Rooms at Maple Creek + https://www.airbnb.com/1 Modern Loft with Space Needle + https://www.airbnb.com/igreen suite seattle - dog frie + https://www.airbnb.com/1 West Seattle Vacation Junction + https://www.airbnb.com/1Awesome Fremont Townhouse! Roc https://www.airbnb.com/1 Maple Creek House in Wedgwood + https://www.airbnb.com/1 Amazing 3BR Fremont Townhome! #bttnet nishoh apm/II District Raluad Corto Record 1 of 3818 No Filter Search WA host id host name - host response time - neighbourhood - neighbourhood group 4193 Jessica within a few hours Dunlap Rainier Valley 35749 Jess & Joey within a day Roosevelt Other neighborhoods 8993 Naddy within an hour South Delridge Delridge 14942 Joyce within a few hours Wallingford Other neighborhoods 19425 Shireen N/A Broadway Capitol Hill 30559 Angielena within a few hours Georgetown Other neighborhoods 30832 Siena within an hour First Hill Downtown 31481 Cassie within an hour Fairmount Park West Seattle 31481 Cassie within an hour Fairmount Park West Seattle 14942 Joyce within a few hours Wallingford Other neighborhoods 35749 Jess & Joey within a day Maple Leaf Northgate 35749 Jess & Joey within a day Maple Leaf Northgate 14942 Joyce within a few hours Wallingford Other neighborhoods 35749 Jess & Joey within a day Maple Leaf Northgate 50893 Chris within a few hours Broadway Capitol Hill 39377 Bob within a few hours Green Lake Other neighborhoods 39377 Bob within a few hours Green Lake Other neighborhoods 33360 Laura within an hour Fairmount Park West Seattle 74305 Darik within a few hours Belltown Downtown 74305 Darik within a few hours Belltown Downtown 74305 Darik within a few hours Belltown Downtown 35749 Jess & Joey within a day Maple Leaf Northgate 79450 Brad & Liz within an hour Adams Ballard 79450 Brad & Liz within an hour Adams Ballard 90437 Ian within an hour Broadway Capitol Hill 91286 Tonyhai N/A Holly Park Beacon Hill 74305 Darik within a few hours Belltown Downtown 95510 Peggy within a day Windermere Other neighborhoods 74305 Darik within a few hours Belltown Downtown 102684 Amanda within a few hours Whittier Heights Ballard 110248 Jamilah within an hour Broadway Capitol Hill 107605 AL within a few hours Loyal Heights Ballard 160789 Darrell N/A Loyal Heights Ballard 165390 Seth within an hour Fremont Other neighborhoods 180441 Pina within a day Mid-Beacon Hill Beacon Hill 189356 Michael within a few hours Wallingford Other neighborhoods 205412 Meg within an hour Fairmount Park West Seattle 212740 Shalini within an hour Stevens Capitol Hill 215230 Carol within a few hours Wedgwood Other neighborhoods 220013 Erik N/A South Lake Union Cascade 212404 Piper + Kent within a few hours Windermere Other neighborhoods 230140 Marie within an hour Genesee West Seattle 238982 Maria & Grahewithin a few hours Fremont Other neighborhoods 215230 Carol within a few hours Wedgwood Other neighborhoods 238982 Maria & Grahawithin a few hours Fremont Other neighborhoods 197752 Korin Tanritbin e fom house Othor anabbarboede city - state - property type accommodates - beds, Seattle WA 2 Seattle WA House 2 1 Seattle WA Apartment 2 1 1 Seattle WA Apartment 2 1 Seattle WA Condominium 2 1 Seattle WA House 2 1 Seattle WA Bed & Breakfast 2 1 Seattle WA House 4 4 5 Seattle WA House 3 2 Seattle WA Apartment 6 6 Seattle WA House 2 1 Seattle WA House 4 2 Seattle WA House 8 3 Seattle WA House 2 1 Seattle WA House 10 5 Seattle House 2 1 Seattle WA House 2 1 Seattle WA Apartment 2 1 1 Seattle WA Apartment 4 2 Seattle WA Apartment 4 2 Seattle WA Apartment 6 3 Seattle WA Apartment 6 2. Seattle WA Cabin 2 1 1 Seattle WA House 2 1 Seattle WA Apartment 5 3 Seattle WA House 10 3 Seattle WA Apartment 2 Seattle WA Apartment 4 1 Seattle WA Apartment 6 3 Seattle WA House 4 2 Seattle WA Apartment 4 2 Seattle WA House 2 1 Seattle WA House 2 2 Seattle WA House 8 3 Seattle House 4 2 Seattle WA House 2 2 Seattle WA House 5 2 Seattle WA House 2 1 Seattle WA House 1 1 Seattle WA Apartment 2 1 Seattle WA Apartment 2 1 Seattle WA Apartment 4 2 Seattle WA Townhouse 1 1 Seattle WA House 1 1 Seattle WA House 4 3 St. TUA HR 2 1 price $120.00 $82.00 $48.00 $90.00 $85.00 $90.00 $99.00 $165.00 $125.00 $120.00 $60.00 $109.00 $310.00 $60.00 $360.00 $40.00 $60.00 $95.00 $107.00 $145.00 $186.00 $137.00 $89.00 $79.00 $119.00 $215.00 $107.00 $165.00 $175.00 $75.00 $199.00 $75.00 $99.00 $275.00 $89.00 $59.00 $75.00 $65.00 $60.00 $220.00 $125.00 $165.00 $97.00 $60.00 $250.00 SRA number of reviews - revie 0 35 297 52 40 79 240 26 14 32 74 12 47 47 26 30 42 21 26 17 38 91 244 WA 7 6 6 22 6 29 404 110 64 0 67 26 182 5 353 37 21 22 20 59 26 41 207 IQ 3 reviewer_id FR listings x 3 reviews listing id. id 7369 3721 7369 4700 6606 5664 9460 8715 7369 9635 9460 9669 10385 12159 10385 12361 10385 12893 10385 14279 10385 14789 7369 15370 10385 16174 10385 16865 10385 18075 7369 18308 10385 18488 10385 24025 7369 24963 11012 25147 7369 25670 11411 26006 10385 27052 11411 29774 5682 30686 19623 31032 19611 31048 7369 31358 7369 31952 10385 32514 10385 33364 10385 34798 11411 35686 10385 36704 25002 37440 7369 39108 11411 39608 25002 39798 5682 40794 10385 41828 5682 42150 25002 44334 11411 45668 5682 47516 25002 47792 5699 10269 Record:Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started