СУФД : Сводная таблица обработки документов

select count(*), doc.docstateid,ds.name from doc
inner join docstate ds on ds.docstateid=doc.docstateid
where createdate >= to_date('21.07.2010 00:00:00', 'DD.MM.YYYY HH24:MI:SS')
group by doc.docstateid,ds.name