order by CASE WHEN 按照指定的顺序排序

order by

CASE WHEN ORG_ID = '高数' THEN 1 ELSE 10 END,

CASE WHEN ORG_ID = '音乐' THEN 2 ELSE 10 END,
CASE WHEN ORG_ID = '表演' THEN 3 ELSE 10 END,
CASE WHEN ORG_ID = '英语' THEN 4 ELSE 10 END,
CASE WHEN ORG_ID = '计算机' THEN 5 ELSE 10 END