SELECT
    approx_percentile_cont(CAST(gold_medals AS Float), 0.50) AS P50_Gold,
    approx_percentile_cont(CAST(gold_medals AS Float), 0.75) AS P75_Gold,
    approx_percentile_cont(CAST(gold_medals AS Float), 0.95) AS P95_Gold,
    approx_percentile_cont(CAST(total_medals AS Float), 0.50) AS P50_Total,
    approx_percentile_cont(CAST(total_medals AS Float), 0.75) AS P75_Total,
    approx_percentile_cont(CAST(total_medals AS Float), 0.95) AS P95_Total,
    CASE
        WHEN continent = 'EUR' THEN 'Europe'
        WHEN continent = 'ASI' THEN 'Asia'
        WHEN continent = 'AME' THEN 'Americas'
        WHEN continent = 'AFR' THEN 'Africa'
        WHEN continent = 'OCE' THEN 'Oceania'
        ELSE 'Other'
    END AS bucket,
    COUNT(_timestamp) as "count"
FROM "oly"
WHERE
    continent IN ('EUR', 'ASI', 'AME', 'AFR', 'OCE')
AND total_medals > 0
GROUP BY bucket
ORDER BY bucket