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

Video: Given a database with a table Orders databricks video

Question 1 Be Honest
« Back   Next databricks Cloud data-analyst Question »
Answer

Full Certification Question

Given a database with a table Orders containing columns OrderId, CustomerId, OrderDate, and Amount, you want to retrieve the list of orders placed by a particular customer, identified by CustomerId = 123, where the order amount is greater than $500. Which SQL query will correctly retrieve this data?