## Swimming_Pools

PoolID | City | HotelName | Size | Price
--- | --- | --- | --- | ---
1 | Miami | Dolphin Bay Hotel | 3000.0 | 29.99
2 | Los Angeles | Pacific Shore Hotel | 4000.0 | 39.99
3 | New York | Times Square Inn | 2800.0 | 27.99
4 | Chicago | Lakeview Lodge | 3500.0 | 36.99
5 | Miami | Sunset Beach Hotel | 3200.0 | 31.99

## HotTubs

TubID | City | HotelName | Occupancy | AccessType
--- | --- | --- | --- | ---
1 | Miami | Dolphin Bay Hotel | 6 | Indoors
2 | Los Angeles | Pacific Shore Hotel | 8 | Outdoors
3 | New York | Times Square Inn | 10 | Roof Top
4 | Chicago | Lakeview Lodge | 12 | Garden
5 | Miami | Sunset Beach Hotel | 8 | Beachside

## Restaurants

ResID | HotelName | Cuisine | AverageCost | OpeningHours
--- | --- | --- | --- | ---
1 | Dolphin Bay Hotel | Italian | 35.0 | 07:00 - 22:00
2 | Pacific Shore Hotel | Seafood | 45.0 | 07:30 - 21:30
3 | Times Square Inn | American | 25.0 | 08:00 - 20:00
4 | Lakeview Lodge | Japanese | 38.0 | 12:00 - 21:30
5 | Sunset Beach Hotel | Fusion | 40.0 | 08:00 - 22:00

## Rooms

RoomID | HotelName | Type | Rate | View
--- | --- | --- | --- | ---
1 | Dolphin Bay Hotel | Standard | 120.0 | City
2 | Pacific Shore Hotel | Deluxe | 200.0 | Ocean
3 | Times Square Inn | Suite | 250.0 | Urban
4 | Lakeview Lodge | Family | 220.0 | Lake
5 | Sunset Beach Hotel | Executive | 300.0 | Beach

## Amenities

AmenID | HotelName | Description | IsIncluded
--- | --- | --- | ---
1 | Dolphin Bay Hotel | Free WiFi access throughout hotel | 1
2 | Pacific Shore Hotel | Private beach area | 0
3 | Times Square Inn | Air conditioning in all rooms | 1
4 | Lakeview Lodge | Bicycle rental service | 0
5 | Sunset Beach Hotel | Onsite spa services | 1

## Activities

ActID | HotelName | ActivityName | Duration | Fee
--- | --- | --- | --- | ---
1 | Dolphin Bay Hotel | Yoga class | 1 hour | 20.0
2 | Pacific Shore Hotel | Surf lesson | 2 hours | 50.0
3 | Times Square Inn | Art workshop | 3 hours | 40.0
4 | Lakeview Lodge | Guided fishing tour | 4 hours | 60.0
5 | Sunset Beach Hotel | Cooking class | 3 hours | 35.0