MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE customer
(
  id INT AUTO_INCREMENT,
  name VARCHAR(100),
  PRIMARY KEY(id)
);
INSERT INTO customer VALUES(NULL, 'Customer A');

CREATE TABLE customercompressor
(
  id INT AUTO_INCREMENT,
  customerid INT NOT NULL,
  name VARCHAR(50),
  PRIMARY KEY(id)
);
INSERT INTO customercompressor VALUES (NULL, 1, 'Compressor A');

CREATE TABLE customercompressorpart
(
  id INT AUTO_INCREMENT,
  customercompressorid INT NOT NULL,
  name VARCHAR(50),
  hourcapacity INT NOT NULL,
  PRIMARY KEY(id)
);
INSERT INTO customercompressorpart VALUES (NULL, 1, 'Air Filter', 1000);
INSERT INTO customercompressorpart VALUES (NULL, 1, 'Oil Filter', 1000);
INSERT INTO customercompressorpart VALUES (NULL, 1, 'Oil', 1000);
INSERT INTO customercompressorpart VALUES (NULL, 1, 'Separator', 2000);
INSERT INTO customercompressorpart VALUES (NULL, 1, 'Sensor', 6000);

CREATE TABLE maintenance
(
  id INT AUTO_INCREMENT,
  maintenancedate DATE,
  customerid INT NOT NULL,
  customercompressorid INT NOT NULL,
  averageworkload DECIMAL(4, 2) NOT NULL,
  PRIMARY KEY(id)
);
INSERT INTO maintenance VALUES (NULL, '2022-01-01', 1, 1, 5.0);
INSERT INTO maintenance VALUES (NULL, '2022-02-01', 1, 1, 5.0);
INSERT INTO maintenance VALUES (NULL, '2022-03-01', 1, 1, 5.0);
INSERT INTO maintenance VALUES (NULL, '2022-04-01', 1, 1, 5.0);

CREATE TABLE maintenancepartreplace
(
  id INT AUTO_INCREMENT,
  maintenanceid INT NOT NULL,
  customercompressorpartid INT NOT NULL,
  PRIMARY KEY(id)
);
INSERT INTO maintenancepartreplace VALUES (NULL, 2, 1);
INSERT INTO maintenancepartreplace VALUES (NULL, 2, 2);
INSERT INTO maintenancepartreplace VALUES (NULL, 2, 3);
INSERT INTO maintenancepartreplace VALUES (NULL, 3, 4);


SELECT * 
FROM customer;

SELECT *
FROM customercompressor;

SELECT *
FROM customercompressorpart;

SELECT *
FROM maintenance;

SELECT *
FROM maintenancepartreplace;


id
name


1
Customer A




id
customerid
name


1
1
Compressor A




id
customercompressorid
name
hourcapacity


1
1
Air Filter
1000

2
1
Oil Filter
1000

3
1
Oil
1000

4
1
Separator
2000

5
1
Sensor
6000




id
maintenancedate
customerid
customercompressorid
averageworkload


1
2022-01-01
1
1
5.00

2
2022-02-01
1
1
5.00

3
2022-03-01
1
1
5.00

4
2022-04-01
1
1
5.00




id
maintenanceid
customercompressorpartid


1
2
1

2
2
2

3
2
3

4
3
4


SELECT mpr.id mprid, m.maintenancedate, m.averageworkload, ccp.id AS ccpid, 
  ccp.name, ccp.hourcapacity,
  m.maintenancedate + INTERVAL (ccp.hourcapacity / m.averageworkload) DAY AS NextDate
FROM maintenancepartreplace AS mpr
INNER JOIN maintenance AS m ON mpr.maintenanceid = m.id
INNER JOIN customercompressorpart AS ccp ON ccp.customercompressorid = m.customercompressorid
WHERE customercompressorpartid = 1;


mprid
maintenancedate
averageworkload
ccpid
name
hourcapacity
NextDate


1
2022-02-01
5.00
1
Air Filter
1000
2022-08-20

1
2022-02-01
5.00
2
Oil Filter
1000
2022-08-20

1
2022-02-01
5.00
3
Oil
1000
2022-08-20

1
2022-02-01
5.00
4
Separator
2000
2023-03-08

1
2022-02-01
5.00
5
Sensor
6000
2025-05-16
id	customercompressorid	name	hourcapacity
1	1	Air Filter	1000
2	1	Oil Filter	1000
3	1	Oil	1000
4	1	Separator	2000
5	1	Sensor	6000
id	maintenancedate	customerid	customercompressorid	averageworkload
1	2022-01-01	1	1	5.00
2	2022-02-01	1	1	5.00
3	2022-03-01	1	1	5.00
4	2022-04-01	1	1	5.00