SQL Yüzde Hesaplama

select
Adi,
count(Adi) GirisSayisi,
convert(decimal(5,1), (count(Adi)* 100.0) / (select count(*) from Test)) YuzdelikDilim
from test
group by Adi
order by GirisSayisi desc