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

Video: Consider a scenario where you have a databricks video

Question 1
« Back   Next databricks data-analyst Exam Question »

Full Certification Question

Consider a scenario where you have a database with a table named ProductSales that contains columns ProductId , SaleDate , Region , and SaleAmount . You need to find the total sales amount for each product in a specific region, say "North America," but only for sales that occurred in the year 2023. Each row in the table represents a sale, where SaleDate is stored in the format YYYY-MM-DD . Which SQL query will correctly aggregate this data?