In the video “9- Subqueries in the SELECT Clause”, why is SELECT needed here to make it works? Why does invoice_total - invoice_average not work? Also, why could we use SELECT here without FROM?
invoice_total - invoice_average