The other solution would be using scalar subquery

select 
   genre,
   count(*) as cnt,
   count(*) * 100.0 / (select count(*) from titles)
from titles
group by genre
order by cnt desc