as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
construct a query to find all the houses located in new york city
user
the following query can be used to find all houses located in new york city: 

select * from houses 
where city = 'new york city'
assistant