The elephant in the room is the failure to meet first normal form. Being fancy with ordinals or order by case statements is beside the point.