Whenever you're ready, walk me through how you'd approach this.
Describe how you would analyze online sales and compute revenue per year for a business case. Explain how you would define revenue, validate transaction data, aggregate sales by calendar or fiscal year, and communicate the results. Identify the tables or fields you would need and discuss how you would handle refunds, cancellations, discounts, taxes, currencies, and duplicate orders.