I can’t get my head around this syntax error, been stuck for an hour. The error is near (SELECT AVG(invoice_total) FROM invoices). It says wrong to use parentheses near select avg().
Hey, so sorry you got stuck! I think you may have to put a comma after AS total_sales and AS average because they are separate columns.
Let me know if that helps at all!