CREATE TABLE PRODUCT (
    CAT         VARCHAR(20) NOT NULL COLLATE PXW_CYRL,
    ART         VARCHAR(20) NOT NULL COLLATE PXW_CYRL,
    PRODUCT_ID  INTEGER NOT NULL,
    NAME        VARCHAR(255) COLLATE PXW_CYRL,
);

CREATE TABLE LOG (
    PRODUCT_ID    INTEGER NOT NULL,
    NUM           INTEGER NOT NULL,
    OPERATION_ID  INTEGER NOT NULL,
    CLIENT_ID     INTEGER,
    SCLAD_ID      INTEGER,
    OPERATOR_ID   INTEGER,
    COLVO         FLOAT,
    DATA          DATE,
    ST            SMALLINT,
    NPP           SMALLINT NOT NULL
);

select b.art,sum(a.colvo*a.st)
from log a,product b where a.product_id
in (select product_id from product where cat="BMW")
and a.product_id=b.product_id
group by 1

create or alter procedure A1
returns (
    ART varchar(20),
    OST numeric(15,2))
as
declare variable ID integer;
begin
  for select product_id, art
  from product
  where cat="BMW"
  into :id, :art
  do
   begin

    select sum(colvo*st) from log where product_id=:id
    into :ost;

    suspend;
   end
end