我有这样的要求，我必须模拟一个excel公式到oraclesql中。由于excel是非常初级的，所有的东西都放在里面，但是sql是有条理的，必须保持一致。
这是excel（业务类别）中的公式：

=IF([@[Order Days]]="","",
IF(OR([@business type]="Probation Touch Point",[@business type]="Referral",
[@business type]="Mystery Shopping"),IF([@[Order Days]]>45,"Allowed","Not Allowed"),
IF(OR(AND([@business status]="Assigned",[@[Order Days]]>60),
AND([@business status]="Pre-Review",[@[Order Days]]>60),
AND([@business status]="In-Review",[@[site]]="Location",[@[Order Days]]>44),
AND([@business status]="In-Review",[@[site]]="Headquarters",[@[Order Days]]>74)),"Permitted",
IF([@business status]="Post-Review",IF([@business review]=0,IF([@[Order Days]]>44,"Allowed","Not 
Allowed"),
IF(OR(AND([@[site]]="Headquarters",[@[Order Days]]>90),
AND([@[site]]="Location",[@[Order Days]]>60)),"Allowed","Not Allowed")),"Not Allowed"))))

由于其突出，有多种 else 在一个单一的公式和它的目的。
我的sql公式：

case when order_days is null then null
when business_type like '%Touch%' or business_type = 'Referral'
or business_type like 'Myster%' and order_days > 45 then 'Allowed'
when (business_status = 'Assigned' and order_days > 60) or
(business_status = 'Pre-Review' and order_days > 60) or
(business_status = 'In-Review' and site like 'Loca%' and order_days > 44) or
(business_status = 'In-Review' and site like 'Head%'  and order_days > 74) then 'Permitted'
when (business_status like 'Post%' or business_type = 0 or order_days > 44) then 'Allowed'
when (site like 'Head%'  and order_days > 90) then 'Allowed'
when (site like 'Loca%'  and order_days > 60) then 'Allowed' else 'Not Allowed'
end as business_category

这个 sql 这个案子是徒劳的，因为它导致了错误的数字。
excel结果：

Business Category         Count of Rows
Allowed                       130
Not Allowed                   1122
Permitted                     200

sql结果：

business_category            Count
Allowed                       980
Not Allowed                   272
Permitted                     200

有人能帮忙吗！