/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 vote300 views2 answers
Copy database mysql
SQL
0 vote360 views1 answer
Sqlite schema structure of a relational database
SQL
3 votes289 views1 answer
Oracle revoke
SQL
-1 vote302 views5 answers
Online sql to linq generator
SQL
12 votes298 views6 answers
Between in sql
SQL
0 vote288 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote301 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote277 views1 answer
Mql5 list all available symbols
SQL
0 vote293 views1 answer
How convert into in in sql query
SQL
10 votes295 views2 answers
Linux command line import mysql database
SQL