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(3) OVER(PARTITION BY Data ORDER BY Conversions) AS 'Ntile' FROM t1;