/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

1 vote183 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote182 views1 answer
Sql query to return field name of a table
SQL
3 votes180 views1 answer
How to find names includes in sql
SQL
0 vote188 views1 answer
T-SQL Create Trigger
SQL
8 votes187 views5 answers
Alter table add column with default value
SQL
-1 vote225 views2 answers
Mysql get day of week
SQL
0 vote135 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote197 views1 answer
Change role postgres
SQL
0 vote181 views1 answer
Best sql collation
SQL
17 votes200 views4 answers
Show tables sql server
SQL