SQL Informes

SELECT
  FORMAT(
    (SELECT
      SEC_TO_TIME(
        AVG(
          TIMESTAMPDIFF(
            SECOND,
            LEAST(`T`.`FECHA`, `T`.`FECHA_COBRO`),
            GREATEST(`T`.`FECHA`, `T`.`FECHA_COBRO`)
          )
        )
      ) AS `AV_TIME`
    FROM
      `tb_tickets_his` `T`
    WHERE DATE(`T`.`FECHA`) = CURDATE() /
      SELECT
        SEC_TO_TIME(
          AVG(
            TIMESTAMPDIFF(
              SECOND,
              LEAST(`T`.`FECHA`, `T`.`FECHA_COBRO`),
              GREATEST(`T`.`FECHA`, `T`.`FECHA_COBRO`)
            )
          )
        ) AS `AV_TIME`
      FROM
        `tb_tickets_his` `T`
      WHERE `T`.`FECHA` BETWEEN CURDATE() - INTERVAL 1 DAY
        AND NOW() - INTERVAL 1 DAY - 1) * 100,
      2
    ) AS `PREV_DAY_DAY`