bahsettigin verilere göre bir tablo olusturdum hocam ve sonucu söyle cikardim.. Emin degilim tam istedigin bu muydu



http://sqlfiddle.com/#!9/6c57b1/1

her halukara karsi kodlari da ekleyeyim..

db olusturma kodu

create table data(number integer);

insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(1);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(5);
insert into data(number) values(7);
insert into data(number) values(7);
insert into data(number) values(8);
insert into data(number) values(9);
insert into data(number) values(12);
insert into data(number) values(18);
insert into data(number) values(21);

sorgu kodu

    SELECT
count(CASE WHEN number between 1 and 10 then totalCount END) AS '1-10 Count',
sum(CASE WHEN number between 1 and 10 then totalCount END) AS '1-10 Value',
count(CASE WHEN number between 11 and 22 then totalCount END) AS '11-22 Count',
sum(CASE WHEN number between 11 and 22 then totalCount END) AS '11-12 Value'
FROM
(SELECT COUNT(*) as totalCount, number FROM `data` GROUP BY number HAVING COUNT(*) > 0)
as t1

senin tablonun yapisini bilmedigim icin benzetmeye calistim. En son (select count ile baslayan) kismi kendi sorguna göre ayarlarsin.. ben db yazilimcisi degilim, daha iyi performans veren kodlar da yazilabilir. Bundan sonrasini grid den okuyarak alabilirsin.. Kodda anlamadigin yeri sorabilirsin

kolay gelsin