/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 vote189 views1 answer
Mysql where don't have string
SQL
0 vote210 views1 answer
Oracle show grants on table
SQL
1 vote201 views1 answer
Sqlite3 read only
SQL
0 vote189 views1 answer
Oracle gather table statistics
SQL
0 vote201 views1 answer
10000000000000000000 am to meters
SQL
0 vote191 views1 answer
Convert rows to columns in sql server
SQL
1 vote238 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote307 views1 answer
Drop check command
SQL
1 vote269 views3 answers
Date_add mysql
SQL
0 vote196 views1 answer
Désinstaller postgresql linux
SQL