select * from customers_info order by case when city is null then country else city end
学到了,原来order by这里也可以使用case when