-- DBCraft AI Studio web demo (simulated Oracle session)
-- Press F8 or the green ▶ to execute. Try an UPDATE, then Commit/Rollback.

SELECT i.invoice_no, c.name, i.total, i.status
  FROM invoices i
  JOIN customers c ON c.customer_id = i.customer_id
 WHERE i.status = 'POSTED';