Write a SQL query to retrieve and aggregate user engagement metrics from a multi-table database schema.
