How to calculate a percentage with condition and group by

Uploaded 5 years ago