Syntax error in subqueries - Select clause

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!

@srsr And the first parenthesis is not closed.