SELECT sale.quantity, sale.price, inv_sell.date, inv_sell.where,;
     SUBSTR( DTOS(inv_sell.date), 3, 4)+ TRANSFORM( inv_sell.where, '99') AS Gr1;
     FROM sale, inv_sell, purchase;
     WHERE (sale.inv_sell = inv_sell.code).AND.;
         (purchase.main_code = sale.purchase).AND.;
         (purchase.goodies = 228);
     INTO CURSOR sql1
     
 SELECT gr1, SUM(quantity) FROM sql1 GROUP BY gr1

SELECT sum(sale.quantity) AS quantity, month(inv_sell.date) AS date, inv_sell.where ;
    FROM sale ;
        INNER JOIN inv_sell ON sale.inv_sell = inv_sell.code ;
        INNER JOIN purchase ON purchase.main_code = sale.purchase ;
    WHERE purchase.goodies = 228 ;
    GROUP BY inv_sell.date, inv_sell.where ;
INTO CURSOR sql1
     

select
    year(inv_sell.date) as yearDate,
    month(inv_sell.date) as monthDate,
    inv_sell.where,
    sum(sale.quantity) as sumQuantity
from sale
inner join inv_sell on inv_sell.code = sale.inv_sell
inner join purchase on purchase.main_code = sale.purchase
where purchase.goodies = 228
group by 
    year(inv_sell.date),
    month(inv_sell.date),
    inv_sell.where