Here is something I found online (https://stackoverflow.com/questions/11937206/sql-query-multiple-columns-using-distinct-on-one-column-only)
select * from tblFruit where tblFruit_ID in (Select max(tblFruit_ID) FROM tblFruit group by tblFruit_FruitType)So in your case it would be something like
select * from song_stats where date_and_time in (Select max(date_and_time) FROM song_stats group by title) AND listeners BETWEEN 5 AND 9But I don't know SQL so I don't know if this is going to work. It might be off by one field or so.