Comment by hans_castorp
2 years ago
The question was "the longest track per album", so I'd expect one row per album as the result (which is what my query does). But adding a LIMIT would not do that.
It might be that the question was "the longest track across all albums" which indeed would require a LIMIT