CREATE TABLE TCATALOG (
    ID             INTEGER NOT NULL,
    IDTYPE         INTEGER,
    STATUS         SMALLINT DEFAULT 0,
    YEAR_REL       DATE,
...

CREATE INDEX TCATALOG_IDX_IDTYPE ON TCATALOG (IDTYPE);
CREATE INDEX TCATALOG_IDX_YEARRELEASE ON TCATALOG (YEAR_REL);
...

CREATE TABLE SPPUBLTYPES (
    ID        INTEGER NOT NULL,
...
    IDORD     INTEGER);

ГОД/ВИД  Учебник | Учебное пособие | Статья из журнала .... (на сейчас тут 15 видов)
2011         68             43                        0             ...
2012         72             28                        2             ...
2013         57             35                        15           ...

select distinct EXTRACT(YEAR from c.YEAR_REL) as THEYEAR
from TCATALOG c
order by EXTRACT(YEAR from c2.YEAR_REL)

select EXTRACT(YEAR from c2.YEAR_REL) as Y, count(c2.ID) as CC from TCATALOG c2
where (c2.STATUS=1) and c2.IDTYPE=1
group by EXTRACT(YEAR from c2.YEAR_REL)
order by EXTRACT(YEAR from c2.YEAR_REL)

select distinct EXTRACT(YEAR from c.YEAR_REL) as THEYEAR
, LJ1.CC as FLD1
from TCATALOG c
left join (select count(c2.ID) as CC, EXTRACT(YEAR from c2.YEAR_REL) as Y from TCATALOG c2
where (c2.STATUS=1) and c2.IDTYPE=1
group by EXTRACT(YEAR from c2.YEAR_REL)) LJ1 on LJ1.Y = EXTRACT(YEAR from c.YEAR_REL)
order by EXTRACT(YEAR from c.YEAR_REL)

select distinct EXTRACT(YEAR from c.YEAR_REL) as THEYEAR
,(select count(c2.ID) as CC from TCATALOG c2
where (c2.STATUS=1) and c2.IDTYPE=1 and EXTRACT(YEAR from c2.YEAR_REL)=EXTRACT(YEAR from c.YEAR_REL)) as CC1
from TCATALOG c
order by EXTRACT(YEAR from c.YEAR_REL)