-----
SELECT order_id, runner_id,
  CASE 
    WHEN pickup_time LIKE 'null' THEN ' '
    ELSE pickup_time 
    END AS pickup_time,
  CASE 
    WHEN distance LIKE 'null' THEN ' '
    WHEN distance LIKE '%km' THEN TRIM('km' from distance)--- remove km from column
    ELSE distance END AS distance,
  CASE 
    WHEN duration LIKE 'null' THEN ' ' 
    WHEN duration LIKE '%mins' THEN TRIM('mins' from duration)-- remove mins
    WHEN duration LIKE '%minute' THEN TRIM('minute' from duration)---remove minute
    WHEN duration LIKE '%minutes' THEN TRIM('minutes' from duration)--remove minutes from duration
    ELSE duration END AS duration,
  CASE 
    WHEN cancellation IS NULL or cancellation LIKE 'null' THEN ''
    ELSE cancellation END AS cancellation
--INTO temp_runner_orders
FROM runner_orders;