SELECT 
itens.orderid,
DATE_ADD(orders.creationdate, INTERVAL -3 HOUR) AS data_pedido,

CASE
    WHEN orders.statusdescription = "Cancelar" THEN "Cancelado"
    WHEN orders.statusdescription = "Cancelado" THEN "Cancelado"
    WHEN orders.statusdescription = "Pronto para o manuseio" THEN "Faturado"
    WHEN orders.statusdescription = "Preparando Entrega" THEN "Faturado"
    ELSE orders.statusdescription
END as status_item, 

name,
sellingprice, 
price, 
imageurl,
quantity,
additionalinfo_brandname
FROM `yooper.[bigquery].vtex_orders_items` AS itens
LEFT JOIN `yooper.[bigquery].vtex_orders` AS orders
ON itens.orderid = orders.orderid