pbj0812의 코딩 일기

0. 목표 - classic retention 계산 1. 실습 1) 테이블 생성 CREATE TABLE sql_test.classic_retention ( id int, is_visited int, dated datetime ); 2) 데이터 삽입 INSERT INTO sql_test.classic_retention(id, is_visited, dated) VALUES(1, 1, '2022-01-01 00:00:00'); INSERT INTO sql_test.classic_retention(id, is_visited, dated) VALUES(2, 1, '2022-01-01 00:00:00'); INSERT INTO sql_test.classic_retention(id, is_visited, dated)..