/*Report SLA*/
SELECT x.order_id , x.outlet_code , x.total_sales, x.payment_method , x.updated_at AS payment_time,x.payment_status  ,
x. transfer_time , x.transfer_status , x.completed_date AS completed_time, x.order_status
FROM kfcdata.`orders_2023-01` x
WHERE order_type IN ('PNP','DRT')