A data engineer is using Amazon Athena for aws video
data-engineer video for a data engineer is using Amazon Athena for querying customer engagement data stored in Amazon S3. The analyst needs to extract
Full Certification Question
A data engineer is using Amazon Athena for querying customer engagement data stored in Amazon S3. The analyst needs to extract information about customer interactions for the year 2023 from a table called interaction_data. The initial query designed to fetch the total interactions per customer for 2023 is not yielding results for some customers known to have interactions in that year. The query needs adjustment to correctly reflect the entire dataset. The original query is: SELECT customer_id, sum(interactions) FROM interaction_data WHERE year = 2023 GROUP BY customer_id How should the data engineer modify the Athena query to ensure it includes all relevant customer data for 2023?