user
Tell me how would you respond to the following request.
Create a query to find the number of people who subscribed to a newsletter in the last year.

assistant
SELECT COUNT(*) from NewsletterSubscriptions WHERE date_subscribed > CURDATE() - INTERVAL 1 YEAR;