Loading…
The finance team wants to tie order status to money. For each order_status, show what was collected and what was returned.
Return order_status, , (succeeded ), , and (paid minus refunded), with amounts rounded to 2 decimals. An order with no payment or no refund counts as 0. Order by .
orderspaid_amountpaymentsrefunded_amountnet_amountorder_statusCreate a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.