[solvesql] SQL 문제 풀이 (5)

1. 첫 주문과 마지막 주문

select
  date(min(order_purchase_timestamp)) as first_order_date,
  date(max(order_purchase_timestamp)) as last_order_date
from
  olist_orders_dataset;

 

2. 많이 주문한 테이블 찾기

select
  *
from
  tips
where
  total_bill > (
    select
      avg(total_bill)
    from
      tips
  );