SELECT CALL_FOR_SERVICE as call_for_service, COUNT(*) as N, PRINTF('%.4f', COUNT(*) * 1.0 / (SELECT COUNT(*) FROM aa_main_table)) as share FROM aa_main_table GROUP BY CALL_FOR_SERVICE
If you think this query provides useful or interesting information submit it as a suggestion to be included as a canned query! Canned queries are displayed in the main page and come with their own URL. Others might find your query useful in their work!
This data as json, CSV