SQL - group by column count into a single row

Question

I'm trying take the result from a group by <col> into a single row, as my graphing library requires a single row for visualizing a stacked bar. For context, I'm using Presto/AWS Athena.

My query is SELECT result, count(*) FROM table GROUP BY result

Essentially

result  | count
skipped | 12
passed  | 13
failed  | 2

Into

skipped | passed | failed
12      | 13     | 2