I am taking a analytics course on coursera and the video instructor executed the following query:
SELECT
Date,
Region,
Small_Bags,
Large_Bags,
XLarge_Bags,
Total_Bags,
Small_Bags + Large_Bags + XLarge_Bags AS Total_Bags_Calc
FROM
yourproject1234.avocado_data.avocado_prices
When I executed this query it did not work for me and I received an error: Unrecognized name: Small_Bags; Did you mean Small Bags? at [4:3]
I looked at the schema to see if I made a spelling mistake but everything seems correct, I rewrote the query again and the same error appears.
How can I make this query work?
kchav is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.