Weekly Retention Analysis question explanation

Objective: Analyze the retention of users on a weekly basis after signing up for a product. Your Task: Write an SQL query to calculate the weekly retention of users based on their sign-up cohort. Can you please elaborate the question? What does retention mean here? Explain as much as you can.