Database: e_commerce
Question: What is the order that total cost the least , and how much is the total cost ?
SQL:
select t1.order_id ,  sum(t2.product_price) from order_items as t1 join products as t2 on t1.product_id  =  t2.product_id group by t1.order_id order by sum(t2.product_price) asc limit 1