SQLize | PHPize | SQLtest

create table sales ( Y_MONTH_SALES VARCHAR2(15) NOT NULL, INN VARCHAR2(15) NOT NULL, OP_TYPE VARCHAR2(15) NOT NULL, E_COMM VARCHAR2(15) NOT NULL, CASH_SUM NUMBER NOT NULL, ECASH_SUM NUMBER NOT NULL, TOTAL_SUM NUMBER NOT NULL, CHEK_CNT NUMBER NOT NULL ); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202001','7722753969','2','2',42372.0,107115.0,149487.0,48); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202012','7719654125','1','2',61760.0,0.0,61760.0,214); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202102','9703000836','1','2',480300.0,3874100.0,4354400.0,131); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202106','3305051742','1','2',389837.0,1719455.15,2240718.0,101); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202208','7723874003','1','2',2751407.0,1661213.0,1936353.0,239); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202202','7743217158','1','2',602081.0,2791965.0,3394046.0,3483); insert into sales(Y_MONTH_SALES, INN, OP_TYPE, E_COMM, CASH_SUM, ECASH_SUM, TOTAL_SUM, CHEK_CNT) values ('202203','7704794345','2','1',0.0,27202.53,27202.53,85); select to_char(to_date(Y_MONTH_SALES,'YYYYMM'),'DD.MM.YYYY') as Y_MONTH_SALES, sum(Total_SUM) as Total_sum, ROUND(AVG(TOTAL_SUM / CHEK_CNT), 2) AVG_Check from sales group by Y_MONTH_SALES;