Which coach has the best performance for team DET in history? What was the winning percentage? Name the coach and the year he coached.
winning percentage refers to DIVIDE(w,g)*100; team DET refers to tmID = 'DET'
SELECT CAST(T2.W AS REAL) / T2.G, T1.firstName, T1.lastName, T2.year FROM Master AS T1 INNER JOIN Coaches AS T2 ON T1.coachID = T2.coachID INNER JOIN ( SELECT coachID FROM Coaches ORDER BY CAST(w AS REAL) / g DESC LIMIT 1 ) AS T3 ON T2.coachID = T3.coachID