select id,
case organization_full_name
when organization_full_name>"D000010" and organization_full_name<"D00100" then "垃圾"
when organization_full_name>"D000100" and organization_full_name<"D01000" then "一般"
when organization_full_name>"D01000" then "优秀"
else "未知"
end "组织"
from idaas_tenant_account;
