AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: You are analyzing sales data in BigQuery to gcp video

Question 1 Be Honest
« Back   Next data-practitioner Certification Question »
Answer

Full Certification Question

You are analyzing sales data in BigQuery to identify trends in customer purchasing behavior over time. Your dataset, sales_data , contains columns for customer_id , purchase_date , product_id , and amount_spent . You want to determine the total amount spent by each customer in the last six months and filter only those customers who spent more than $1,000. Which SQL query should you execute in BigQuery?