/SQL/Sql use with to get value counts and percentages

Sql use with to get value counts and percentages

SELECT event, 
       count(event) as event_count,
       count(event) * 100.0 / (select count(*) from event_information) as event_percent
FROM event_information
group by event

Source: stackoverflow.com

Similar codes

0 vote281 views1 answer
Oracle date summer time
SQL
8 votes320 views2 answers
Between operator
SQL
1 vote295 views1 answer
Postgres cast as currency format
SQL
0 vote270 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote232 views1 answer
Sql count how many times a value appears
SQL
10 votes242 views1 answer
Oracle view dependencies
SQL
1 vote274 views1 answer
Display total number of tables in mysql
SQL
6 votes306 views2 answers
Difference between join vs union
SQL
0 vote310 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote340 views1 answer
How to find unique element in sql
SQL