In 1997, how many loss did the coach have who temporary coached Tampa Bay Lightning? Indicate his/her coach ID.
temporary coached refers to notes = 'interim'; number of loss refers to L (to add)
SELECT SUM(T1.l), T1.coachID FROM Coaches AS T1 INNER JOIN Teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.notes = 'interim' AND T1.year = '1997' AND T2.name = 'Tampa Bay Lightning' GROUP BY T1.coachID