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
write sql query to select the customers who have signed up within the last 7 days.
user
select * from customers 
where date_signed_up > date_sub(curdate(), interval 7 day);
assistant