Sales database
Read only access to the Acme sales database (MySQL).Customer
Name, country, segment (small, mid or enterprise), and since when they are a customer.
Order
The customer who placed it, status (draft, paid, shipped or cancelled), total amount and currency, when it was placed, when it shipped. Each order has lines: product, quantity, unit price.
Product
Name, category, whether it is still on sale.
Invoice
The order it bills, number, issue date, payment date. Unpaid means no payment date yet.
Revenue
Sum of paid and shipped orders in a period, by the date they were placed. Draft and cancelled orders never count.
Do you like what you are reading? Subscribe to receive updates.
Unsubscribe anytime
Powered by Seed HypermediaOpen App