#Compute percent of column

In SQL, to get the percentage of a row over the column total, you can use a window function to sum the column, and then divide each row by this total:

SELECT
    wait_time,
    COUNT(*) AS n,
    n*1.0 / SUM(n) OVER () AS pct
FROM rides
GROUP BY 1
ORDER BY 1