Listening Mix by Membership Tier

Problem

A media app logs how long each member spends in two modes. Table `Plays` has one row per session: `play_id`, `member_id`, `mode` (either `audio` or `video`), and `minutes` spent (decimal). Table `Members` maps each `member_id` to a membership `tier` (such as `Basic` or `Premium`).

For each membership tier, compute what percentage of the tier's total minutes was spent in `audio` mode and what percentage in `video` mode. Round both percentages to two decimal places.

Return `tier`, `audio_pct`, and `video_pct`. Order is not important.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns tier, audio_pct, video_pct.

Starter code (SQL)

SELECT *
FROM Plays;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium