By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE timemeasure (
`time` varchar(20),
`measure_name` VARCHAR(13),
`measure_value` INTEGER
);
INSERT INTO timemeasure
(`time`, `measure_name`, `measure_value`)
VALUES
('12/1/2021 0:00', 'volume', '791'),
('12/1/2021 0:00', 'successVolume', '791'),
('12/1/2021 0:01', 'volume', '1261'),
('12/1/2021 0:01', 'successVolume', '1261'),
('12/1/2021 0:02', 'volume', '1332'),
('12/1/2021 0:02', 'successVolume', '1332'),
('12/1/2021 0:03', 'volume', '1145'),
('12/1/2021 0:03', 'successVolume', '1145');
SELECT a.`time`, (a.`measure_value` / b.`measure_value`) * 100 as successRate
FROM
(SELECT `time`, `measure_name`, `measure_value` FROM timemeasure WHERE `measure_name` = 'volume' ) a
INNER JOIN (SELECT `time`, `measure_name`, `measure_value` FROM timemeasure WHERE `measure_name` = 'successVolume' ) b
ON a.`time` = b.`time`
| time | successRate |
|---|---|
| 12/1/2021 0:00 | 100.0000 |
| 12/1/2021 0:01 | 100.0000 |
| 12/1/2021 0:02 | 100.0000 |
| 12/1/2021 0:03 | 100.0000 |