첫 주문과 마지막 주문 _ Lv1

 

Solution

SELECT 
  SUBSTR(MIN(order_purchase_timestamp), 1, 10) AS first_order_date,
  SUBSTR(MAX(order_purchase_timestamp), 1, 10) AS last_order_date
FROM olist_orders_dataset