/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 vote333 views1 answer
Postgres list all stored procedures query
SQL
0 vote211 views1 answer
Vbscript clean up ADODB.Recordset
SQL
16 votes203 views1 answer
CTE statement sql server
SQL
0 vote193 views1 answer
Create boolean column in MySQL with false as default value?
SQL
2 votes194 views1 answer
Oracle sql query to make column data uppercase
SQL
2 votes186 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote214 views1 answer
Oracle sql number to varchar2
SQL
1 vote229 views1 answer
Oracle drop temporary table
SQL
0 vote215 views1 answer
Use between operator in mysql
SQL
0 vote215 views1 answer
Default column value in sql same as another column laravel
SQL