Write a SQL query on a whiteboard to extract specific user engagement metrics across multiple joined tables, handling null values and duplicates.
