第1步：获取列名：

select distinct BoxName from t

例如，此查询将返回：

BoxName
-----------
Small Box    
Medium Box
Large Box
Regular Box
Jumbo Box

第二步：组装一个动态查询。现在您已经知道了列，可以将主查询准备为：

select
  Route,
  max(case when BoxName = 'Small Box' then price end) as `Small Box`,
  max(case when BoxName = 'Medium Box' then price end) as `Medium Box`,
  max(case when BoxName = 'Large Box' then price end) as `Large Box`,
  max(case when BoxName = 'Regular Box' then price end) as `Regular Box`,
  max(case when BoxName = 'Jumbo Box' then price end) as `Jumbo Box`
from t
group by Route
order by max(display_order)