How should be the where clause written for the configured input parameters in such a way that it achieves below SQL query?

Refer to the exhibit.

How should be the where clause written for the configured input parameters in such a way that it achieves below SQL query?
A . WHERE city := ${city} AND state := ${state}
B . WHERE city = attributes.city AND state = attributes.state
C . WHERE city = :city AND state = :state
D . WHERE city := city AND state := state

View Answer

Answer: C

Explanation:

Correct syntax to use where clause is WHERE city = :city AND state = :state