Kod:
select Subject, (select count(Subject) from Deneme where Subject like '%kesin%'),(select count(Subject) from Deneme where Subject not like '%kesin%') from Deneme group by Subject;
select Subject, (select count(Subject) from Deneme where Subject like '%kesin%'),(select count(Subject) from Deneme where Subject not like '%kesin%') from Deneme group by Subject;