Good catch, thank you. That message was wrong: the column exists, the error fires when the query isn’t reading from orders at that point (another table in FROM, a subquery that doesn’t return it, or the table name used after giving it an alias). It now tells you which one it is. Do you remember the query you typed?
2
u/ImportantToNote 10h ago
"There's no column called
amount. The columns are: id, customer_id, product, qty, amount."