Share of Active Passengers
Product wants to know what share of registered passengers actually use the service — i.e. have booked at least one cabin. Compute this percentage in the 0-to-100 range with two decimal places.
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.
| active_pct |
|---|
| 75.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in