An analyst has written the following code: SELECT * FROM Cust_table WHERE age > 60 AND City = "New York" Which of the following criteria is the analyst retrieving?

Sign in or unlock DA0-001 to reveal the answer and full explanation for question #291. The question stem and answer options stay visible for context.

Data Concepts and Environments

Question

An analyst has written the following code:

SELECT * FROM Cust_table WHERE age > 60 AND City = "New York" Which of the following criteria is the analyst retrieving?

Options

AAll customers older than age 60 in New York state
BAll customers aged 60 and older in New York state
CAll customers older than age 60 in New York City
DAll customers younger than age 60 in New York City

Unlock DA0-001 to see the answer

You've previewed enough free DA0-001 questions. Unlock DA0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock DA0-001 - $49.99 / 30 days Sign in

Topics

#SQL Syntax#Data Querying#WHERE Clause#Comparison Operators

Full DA0-001 Practice