Orders has one row per order. Order_lines has one row per item. The report needs one row per day with total order revenue from orders.total_amount.
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in