A data analyst is required to query the data in my_table. They want to return the values in columns user_id and email_address where records fit the following filter criteria: age is greater than 25 and country is Canada. The analyst does not want to return values from any other columns.

Which following SQL will accomplish the above task?_

Exam-Like

SELECT * FROM my_table WHERE age > 25 AND country = ’Canada’;*_

4.8%

SELECT user_id, email_address FROM my_table WHERE age > 25 AND country = ’Canada’;_

89.3%

SELECT age, country FROM my_table WHERE age > 25 AND country = ’Canada’;_

3.6%

SELECT user_id, email_address FROM my_table WHERE age = 25 AND country > ’Canada’;_

2.4%

Databricks Certified Data Analyst - Associate