• order by a required.

    i need the result should be as i mentioned