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.
2
WHERE TABLE_NAME = 'avocado_prices'```
hope this can solve the query u wanted if it does'nt do let me know!! i'll explain more and we'll definately find a solution!!
Vivek Kr. Dixit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.