select cast((100/count(id))*(count(case when estado="Realizado" then 1 end)) AS INT) as avance from tareas where idactividad in (select id from actividades where idproyecto=4) GROUP by idactividad