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 retrieve all users who have signed up in the last 30 days
user
select * from users 
where date_diff(now(), date_signed_up, day) < 30
assistant