airbnb/practice-2.sql at main · marcoskkk/airbnb · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- Can I see the AirBnb URL for all rentals that can accommodate my group of 16?

SELECT url, accommodates
FROM listings
WHERE accommodates = 16;

-- +---------------------------------------+--------------+
-- | https://www.airbnb.com/rooms/1321332  | 16           |
-- | https://www.airbnb.com/rooms/3172794  | 16           |
-- | https://www.airbnb.com/rooms/12963261 | 16           |
-- | https://www.airbnb.com/rooms/13478467 | 16           |
-- | https://www.airbnb.com/rooms/13884932 | 16           |
-- | https://www.airbnb.com/rooms/15287352 | 16           |
-- | https://www.airbnb.com/rooms/16453692 | 16           |
-- | https://www.airbnb.com/rooms/16662423 | 16           |
-- | https://www.airbnb.com/rooms/19952780 | 16           |
-- | https://www.airbnb.com/rooms/21321497 | 16           |
-- | https://www.airbnb.com/rooms/21488226 | 16           |
-- | https://www.airbnb.com/rooms/22352557 | 16           |
-- | https://www.airbnb.com/rooms/23234733 | 16           |
-- | https://www.airbnb.com/rooms/25232674 | 16           |
-- | https://www.airbnb.com/rooms/25238570 | 16           |
-- | https://www.airbnb.com/rooms/25367014 | 16           |
-- | https://www.airbnb.com/rooms/25682427 | 16           |