Captain or Guest
The platform splits users between earners (captains who own cabins) and consumers (guests). For each user output id, name, and a captain or guest label. If a person owns multiple cabins they will appear multiple times — one row per cabin.
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 | name | status |
|---|---|---|
| 1 | Sophia | captain |
| 1 | Sophia | captain |
| 2 | Liam | captain |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in