SUM(
IF
[f_business_time] >= DATETRUNC('day', DATEADD('day', -1, NOW()))
AND [f_business_time] < DATETRUNC('day', NOW())
AND ((10000000 <= [f_trans_buyer_user_id] AND [f_trans_buyer_user_id] <= 999999999999999)
OR ([f_trans_buyer_user_id] >= 100000000000000000))
THEN [f_trans_amount]
ELSE 0 END
)