Cabins with All Amenities
The platform's premium tier consists of cabins with the full amenity package. Output every cabin where has_balcony, has_wifi, has_minibar, and has_seaview are all true at the same time.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| id | has_wifi | captain_id | daily_rate | cabin_class | has_balcony | has_minibar | has_seaview | deck_location |
|---|---|---|---|---|---|---|---|---|
| 2 | true | 2 | 120.00 | Deluxe suite | true | true | true | Deck 8 Aft |
| 4 | true | 1 | 200.00 | Owner suite | true | true | true | Deck 9 Aft |
| 6 | true | 4 | 250.00 | Royal suite | true | true | true | Deck 10 Aft |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in