nora-staubin

select 
order_id
,max(price) 
from {{raw.e_commerce_sample.webshop_order_line}} 
group by order_id

nora-staubin

select 
  order_id, 
  max(price) 
from 
  {{raw.e_commerce_sample.webshop_order_line}}

nora-staubin

select 
  max(price) 
from 
  {{raw.e_commerce_sample.webshop_order_line}}

nora-staubin

select 
  order_id 
from 
  {{raw.e_commerce_sample.webshop_order_line}}

nora-staubin

select 
  order_id, 
  sum(quantity * price) as total_revenue_per_order 
from 
  {{raw.e_commerce_sample.webshop_order_line}} 
group by 
  order_id 
order by 
  total_revenue_per_order desc

nora-staubin

select 
  count(id) as orders_received, 
  extract(
    month 
    from 
      (
        parse_date('%d / %m / %Y', received_at)
      )
  ) as recived_at_month, 
  extract(

nora-staubin

select 
  count(id) as orders_received, 
  extract(
    month 
    from 
      (
        parse_date('%d / %m / %Y', received_at)
      )
  ) as recived_at_month, 
  extract(

nora-staubin

select 
  count(id) as orders_received, 
  extract(
    year 
    from 
      (
        parse_date('%d / %m / %Y', received_at)
      )
  ) as recived_at_year 
from 

nora-staubin

select 
  customer_id, 
  count(id) as number_of_orders 
from 
  {{raw.e_commerce_sample.webshop_order}} 
group by 
  customer_id

nora-staubin

select 
  max(price * quantity) as highest_order_line_value 
from 
  {{raw.e_commerce_sample.webshop_order_line}}