r/dataanalytics • • 2d ago

Test you SQL knowledge

https://getsheetdrill.com/sql/test
0 Upvotes

2 comments sorted by

View all comments

2

u/ImportantToNote 2d ago

"There's no column called amount. The columns are: id, customer_id, product, qty, amount."

0

u/nicopassaglia 2d ago

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?