• maybe you were missing the order by? All the solutions seem workable to me.