[SQL문제풀기] 첫 주문과 마지막 주문

문제

solvesql.com

https://solvesql.com/problems/first-and-last-orders/

SQLite

내가 작성한 정답

select strftime('%Y-%m-%d',min(order_purchase_timestamp)) first_order_date, 
       date(max(order_purchase_timestamp)) last_order_date
from olist_orders_dataset;