select *
from customers_info
order by case when city is null then country else city end

学到了,原来order by这里也可以使用case when