create schema test;
create table test.sp_keyword_list
(
    id                    bigint unsigned auto_increment
        primary key,
    record_id             bigint                                not null,
    created_at            timestamp default current_timestamp() not null
)
    charset = utf8mb3;

create table test.sponsored_products_14d_metrics
(
    report_date            date                                   not null,
    record_id              bigint                                 null
)
    engine = Columnstore
    charset = utf8mb3;

INSERT INTO test.sp_keyword_list
    (record_id, created_at) VALUES
    (106824737247411, '2022-10-31 20:08:48');
INSERT INTO test.sponsored_products_14d_metrics (record_id,report_date) VALUES
                                                                             (106824737247411, '2022-11-04'),
                                                                             (106824737247411, '2022-11-05'),
                                                                             (106824737247411, '2022-11-06'),
                                                                             (106824737247411, '2022-11-07'),
                                                                             (106824737247411, '2022-11-08');
