Premium problem44. High-Frequency Support Users

Medium Locked

support_calls(call_id, user_id, issue_type, called_at)

For each issue type in September 2026, return what percentage of the users who contacted support about it did so at least twice.

Return issue_type and repeat_user_pct rounded to two decimals, ordered by issue_type.

The denominator is distinct users for that issue, not calls, so a single user calling five times is one user, not five.

Tables

support_calls

call_id  user_id  issue_type  called_at
-------  -------  ----------  -------------------
1        10       billing     2026-09-01 10:00:00
2        10       billing     2026-09-02 10:00:00
3        11       billing     2026-09-03 10:00:00
4        12       login       2026-09-01 10:00:00
5        12       login       2026-09-02 10:00:00
6        12       login       2026-09-03 10:00:00
7        12       login       2026-09-04 10:00:00
8        12       login       2026-09-05 10:00:00
... 2 more row(s)

Expected result

issue_type  repeat_user_pct
----------  ---------------
billing     50.00
login       100.00
shipping    0.00

Premium problem

This one's part of Premium. Unlock the full MySQL track plus every other premium problem on the site.

Write one SELECT query