MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.30


CREATE TABLE engagement(
	deal_id INT,
    min_call_time DATETIME DEFAULT NULL,
    max_call_time DATETIME DEFAULT NULL,
    count_call INT DEFAULT 0,
    min_meeting_time DATETIME DEFAULT NULL,
    max_meeting_time DATETIME DEFAULT NULL,
    count_meeting INT DEFAULT 0,
    count_activities INT DEFAULT 0,
    PRIMARY KEY (deal_id)
);


CREATE TABLE calendly_data(
	id INT,
	deal_id INT,
    count_meetings INT,
    count_active INT,
    count_cancelled INT,
    min_start_time DATETIME,
    max_start_time DATETIME,
    PRIMARY KEY (id),
    FOREIGN KEY (deal_id) REFERENCES engagement(deal_id)
);
CREATE TABLE calendly_data(
	id INT,
	deal_id INT,
    count_meetings INT,
    count_active INT,
    count_cancelled INT,
    min_start_time DATETIME,
    max_start_time DATETIME,
    PRIMARY KEY (id),
    FOREIGN KEY (deal_id) REFERENCES engagement(deal_id)
);

Table 'calendly_data' already exists