how to compute percentage in mysql/sql when 2 group by conditions are present

how to compute percentage in mysql/sql when 2 group by conditions are present

I have a derived table with above structure. I need to compute the percentage of number of events of each organizer for each title. i.e. I'm expecting a result like:

id title count organizer

1   music  4     2

2   sports  6    2

3   music   2     3

I have a derived table with above structure. I need to compute the percentage of number of events of each organizer for each title. i.e. I'm expecting a result like:

organizer  title percentage

2 music 40%

2 sports 60%

3 music 100%

The way I'm doing it without organizer in consideration produces the percentage aggregating all the values easily but introducing organizer messes it all up. Can anyone help me here??

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

MySQL Database Bootcamp: Go from SQL Beginner to Expert | Simpliv

MySQL Database Bootcamp: Go from SQL Beginner to Expert

SQL Full Course - SQL Tutorial For Beginners - MySQL Essentials - SQL Training

This SQL Full Course video will cover all the topics of SQL starting from scratch. This video is great for beginners who want to learn SQL and for advanced people to brush up their skills.

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts