一个表数据纵向转横向的SQL

select t.meal_order_id MEAL_ORDER_ID,
       SUM(case t.cas_code when 'F' then t.book_st_qty else 0 end) as F,
       SUM(case t.cas_code when 'C' then t.book_st_qty else 0 end) as C,
       SUM(case t.cas_code when 'Y' then t.book_st_qty else 0 end) as Y,
       SUM(case t.cas_code when 'P' then t.book_st_qty else 0 end) as P,
       SUM(case t.cas_code when 'G' then t.book_st_qty else 0 end) as G,
       SUM(case t.cas_code when 'CP' then t.book_st_qty else 0 end) as CP,
       SUM(case t.cas_code when 'CA' then t.book_st_qty else 0 end) as CA,
       SUM(case t.cas_code when 'PL' then t.book_st_qty else 0 end) as PL,
       SUM(case t.cas_code when 'BP' then t.book_st_qty else 0 end) as BP,
       SUM(case t.cas_code when 'TA' then t.book_st_qty else 0 end) as TA,
       SUM(case t.cas_code when 'TB' then t.book_st_qty else 0 end) as TB
from t_yk_meal_order_cas t
group by t.meal_order_id