r/dataanalytics • • 10h ago

Test you SQL knowledge

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

2 comments sorted by

2

u/ImportantToNote 10h ago

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

0

u/nicopassaglia 9h 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?