CREATE TABLE quarterly_report_status (
id INT NOT NULL auto_increment PRIMARY KEY,
report_status VARCHAR(20) NOT NULL,
report_updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
PARTITION BY RANGE (TO_DAYS(report_updated)) (
PARTITION p202301 VALUES LESS THAN (TO…