Miscellany

UPDATE C3_Stats AS c

SET
        MTTR_In_Hours = (
                SELECT t1.MTTR_In_Hours FROM (
                        SELECT
                            	c.SR_Number,
                               	(TIMESTAMPDIFF(SECOND, c.SR_Create_Timestamp, c.SR_Close_Timestamp )/60/60) AS MTTR_in_Hours
                        FROM
                               	C3_Ticket_Creator c
                        ) t1
                WHERE c.SR_Number = t1.SR_Number
                );