Ozzie Hive Script

Hi folks,

Can I use the below script in Ozzie workflow?

WITH order_data (order_date, product_name, amount)

AS (

SELECT

  order_date,

  product_name,

  SUM(i.quantity * i.list_price * (1 - discount))

FROM sales.orders o

INNER JOIN sales.order_items i

  ON i.order_id = o.order_id

INNER JOIN production.products p

  ON p.product_id = i.product_id

GROUP BY order_date,

         product_name

)

SELECT * FROM order_data;