I have the following SQL Code :-
SELECT * INTO #Temp4 FROM ( SELECT tt5.[Venue], tt5.[BID], MIN(tt1.[Date]) AS [Date], tt5.[Display / Flypast], SUM(tt1.[Duration]) AS [Duration (mins)], (SELECT DISTINCT '; ' + t5.[Aircraft Combined] FROM #Temp5 t5 WHERE tt5.[Venue] = t5.[Venue] AND tt5.[BID] = t5.[BID] AND tt5.[Display / Flypast] = t5.[Display / Flypast] FOR XML PATH ('')) [Aircraft Combined], SUM(tt5.[Dakota and Fighters in Same Slot?]) AS [Dakota and Fighters in Same Slot?]
Could someone please tell me, what the Python Code equivalent would be ?
Any help and info would be much appreciated.