Here is something I found online (

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 9

But 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.