CASE name WHEN 'Low' THEN 24 WHEN 'Medium' THEN 8 ELSE 1 END AS target_response_hrs, CASE name WHEN 'Low' THEN 120 WHEN 'Medium' THEN 48 ELSE 12 END AS target_resolution_hrs ...

select * from pa.pa_transaction_interface_all where batch_name = 'AP-123456'; select * from pa.pa_transaction_interface_all order by creation_date desc; select * from pa.pa_transaction_interface_all ...