Glean Data Manipulation (SQL/Python) Interview Questions

Compute DAU and rolling MAU with zero days

You have two tables in PostgreSQL: Tables users - user_id (STRING / INT, PK) - signup_date (DATE) logins - user_id (STRING / INT, FK → users.user_id) ...