/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 vote269 views2 answers
Mysql multiply
SQL
0 vote267 views1 answer
Drop all tables in azure sql database
SQL
0 vote244 views2 answers
Spring properties file for db
SQL
0 vote224 views2 answers
Jupyter notebook connect to database
SQL
11 votes293 views6 answers
Distinct sql
SQL
0 vote280 views1 answer
Mysql where in keep order
SQL
0 vote290 views1 answer
Mysql add text to existing field
SQL
0 vote283 views1 answer
Sp in sql server
SQL
11 votes302 views2 answers
Oracle saurce code
SQL
1 vote291 views1 answer
Retrieve meaning
SQL