A data engineer is using Amazon Athena to analyze sales data that is in Amazon S3. The data engineer writes a query to retrieve sales amounts for 2023 for several products from a table named sales_data. However, the query does not return results for all of the products that are in the sales_data table. The data engineer needs to troubleshoot the query to resolve the issue.
The data engineer's original query is as follows:
SELECT product_name, sum(sales_amount)
FROM sales_data -
WHERE year = 2023 -
GROUP BY product_name -
How should the data engineer modify the Athena query to meet these requirements?
GiorgioGss
Highly Voted 1 year, 3 months agopikuantne
Highly Voted 8 months, 1 week agoYUICH
Most Recent 5 months, 1 week agoUdyan
6 months agoMLOPS_eng
6 months, 2 weeks agoAssassin27
6 months, 2 weeks agokailu
6 months, 2 weeks agoShatheesh
9 months, 1 week agovaluedate
1 year, 1 month agoVerRi
1 year, 1 month agoJust_Ninja
1 year, 1 month agoSnape
1 year, 2 months agokhchan123
1 year, 2 months agochris_spencer
1 year, 2 months agoChristina666
1 year, 2 months agoaltonh
7 months, 1 week agokj07
1 year, 3 months agoDevoteamAnalytix
1 year, 2 months agoFelix_G
1 year, 3 months agoFuriouZ
1 year, 3 months agorralucard_
1 year, 5 months agonyaopoko
1 year, 3 months ago