Cabins with the full amenity package
The platform's premium tier consists of cabins that offer the full amenity package. Return 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 | cabin_class | deck_location | has_balcony | has_wifi | has_minibar | has_seaview | daily_rate | captain_id |
|---|---|---|---|---|---|---|---|---|
| 2 | Deluxe suite | Deck 8 Aft | true | true | true | true | 120.00 | 2 |
| 4 | Owner suite | Deck 9 Aft | true | true | true | true | 200.00 | 1 |
| 6 | Royal suite | Deck 10 Aft | true | true | true | true | 250.00 | 4 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid