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
create a query to find the number of people who subscribed to a newsletter in the last year.
user
select count(*) from newslettersubscriptions where date_subscribed > curdate() - interval 1 year;
assistant