select
sum(case when ename like '%[%]%' and ename not like '%[%][%]%' then 1 else 0 end)
as single_percent_count,
sum(case when ename like '%[%][%]%' then 1 else 0 end)
as double_percent_count
from (
values('vi%kas'),('vi%%kas'),('vi%kas'),
('vi%%kas'),('vi%kas'),('vi%%kas'),('vi%%kas')) as emp(ename)