fashionly_basic_query

fashionly_basic_query.sql

SELECT
  DATE(o.created_at) AS order_created_date,
  SUM(oi.sale_price) AS revenue,
  COUNT(DISTINCT o.order_id) AS order_count,
  COUNT(DISTINCT o.user_id) AS customers_orderd
FROM
  `bigquery-public-data.thelook_ecommerce.orders` o
LEFT JOIN
  `bigquery-public-data.thelook_ecommerce.order_items` oi
ON
  o.order_id = oi.order_id
WHERE
  o.status NOT IN ('Cancelled',
    'Returned')
GROUP BY
  1
ORDER BY
  1 desc