Task

Asana’s growth team wants to measure how many new users activate quickly after signup. Write a SQL query to identify users who activated within 24 hours of signup.

Requirements

1. Return each user_id whose activated_at timestamp is within 24 hours after signup_at.
2. Exclude users who never activated or whose activation happened before signup.
3. Include signup_at, activated_at, and the activation lag in hours.
4. Order the result by user_id.

Table Definition

asana_user_lifecycle

Sample Data

Expected Output