The operations team needs a unified view of each order's payment and shipping status. For each order, show the order id, order_date, total_amount, payment method, payment status, shipping carrier, and shipping status. Include orders even if they have no shipping record yet.
Schema
🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql
Run your query to see results
Press Ctrl + Enter to execute