Kod:
IIf([TotalItmMast]![FinalPrice4] Is Null,[TotalItmMast]![FinalPrice3],IIf([TotalItmMast]![FinalPrice3] Is Null,[TotalItmMast]![FinalPrice2],IIf([TotalItmMast]![FinalPrice2] Is Null,[TotalItmMast]![FinalPrice],[TotalItmMast]![FinalPrice])))
Kod:
SELECT
IIF(order_status = 1,'Pending',
IIF(order_status=2, 'Processing',
IIF(order_status=3, 'Rejected',
IIF(order_status=4,'Completed','N/A')
)
)
) order_status,
COUNT(order_id) order_count
FROM
sales.orders
WHERE
YEAR(order_date) = 2018
GROUP BY
order_status;