Report revenue by week. Label each week as YYYY-Www using SQLite's strftime('%Y-W%W', order_date), where %W is the week of the year (00–53) with weeks starting on Monday. Return week, orders and revenue for each week that has orders, sorted by week.
Schema
customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)