Write a query to retrieve the CD title, track title, and track length of (only) the longest track on each CD. If multiple tracks are tied for longest on a CD (which does not occur in the sample data) each of them would be retrieved.(SQL)

Expected results: cdtitle trktitl tra tength Giant steps syeeda s song Flute 7.030 Swing clouds 7.200 Moondance d caravan 4.450