Getting percentage of calculated fields

[gmc1103]

Hello

In my query i  have x activities, then i have the count of how many still to be executed, i need to get the percentage of the total executed

I mean i have 200 activities, 20 have been executed, so i want to have 10% done

My query is this one but missing the percentage field

SELECT COUNT(*) AS total,
                                        IFNULL(SUM(CASE WHEN (t1.dataPrevista >= CURDATE() OR ae.Fim <= CURDATE()) THEN 1 ELSE 0 END),0) AS exec
                                        FROM atividades AS t1
                                        INNER JOIN anosescolares AS ae ON (t1.`idAnoEscolar` = ae.idAnoEscolar)
                                        WHERE ae.Estado = 1;

  any help?

[Barand]

Perhaps

exec * 100 / total

[gmc1103]

Hi Barand

Done

Thanks