By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| @sql2 |
|---|
| SEC_TO_TIME( SUM( TIME_TO_SEC(TIME_FORMAT(IF(callDate = "07/01/2020" ,`callLength`, NULL), "%H:%i:%s")))) AS "07/01/2020",SEC_TO_TIME( SUM( TIME_TO_SEC(TIME_FORMAT(IF(callDate = "07/02/2020" ,`callLength`, NULL), "%H:%i:%s")))) AS "07/02/2020",SEC_TO_TIME( SUM( TIME_TO_SEC(TIME_FORMAT(IF(callDate = "07/03/2020" ,`callLength`, NULL), "%H:%i:%s")))) AS "07/03/2020" |
| callerName | 07/01/2020 | 07/02/2020 | 07/03/2020 |
|---|---|---|---|
| Client A | 0:00:23 | 0:01:23 | 0:011:23 |
| Client B | 0:15:23 | 0:12:23 | 0:22:23 |
| Client C | 0:7:10 | 0:3:10 | 0:23:10 |
| total | 00:22:56 | 00:16:56 | 00:56:56 |