MySQL 잔존율 쿼리 (SP & Query)

CREATE TABLE CREATE TABLE `fact_retention` ( `stats_date` date NOT NULL, `date` date NOT NULL, `period` int NOT NULL, `age` int NOT NULL, `new_users` int DEFAULT NULL, `retained_users` int DEFAULT NULL, `retention` float DEFAULT NULL, PRIMARY KEY (`stats_date`,`date`,`period`,`age`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 수집 CREATE PROCEDURE `db_canmore_statistics`.`us..

2022.08.30