SQLize Online / PHPize Online  /  SQLtest Online

/*Создаём таблицу*/ Create table t1 (data date, Medium varchar(40), Conversions integer); /*Наполняем данными; предположение - данные есть на каждую дату*/ insert into t1 values ('10-05-2200', 'cpa', 1), ('10-05-2200', 'cpc', 2), ('10-05-2200', 'organic', 1), ('11-05-2200', 'cpa', 1), ('11-05-2200', 'cpc', 3), ('11-05-2200', 'organic', 2), ('11-05-2200', 'direct', 1), ('12-05-2200', 'cpc', 1), ('12-05-2200', 'organic', 2); Select * From t1; SELECT Data, Medium, Conversions, ROW_NUMBER() OVER(PARTITION BY Data ORDER BY Conversions) AS Row_number, RANK() OVER(PARTITION BY Data ORDER BY Conversions) AS Rank, DENSE_RANK() OVER(PARTITION BY Data ORDER BY Conversions) AS Dense_Rank, NTILE(2) OVER(PARTITION BY Data ORDER BY Conversions) AS Ntile FROM t1; SELECT Data, Medium, Conversions, SUM(Conversions) OVER(PARTITION BY Data) AS Sum, COUNT(Conversions) OVER(PARTITION BY Data) AS Count, AVG(Conversions) OVER(PARTITION BY Data) AS Avg, MAX(Conversions) OVER(PARTITION BY Data) AS Max, MIN(Conversions) OVER(PARTITION BY Data) AS Min FROM t1;