Suppose you have two tables related to social media user engagement: user_activity and user_comments.

• user_activity table contains information about user activity on the platform, including user_id, likes, shares, and follows.
• user_comments contains user comments on posts, including user_id, post_id, and comment_text.

You want to create a report to measure the following metrics:

• Number of Likes
• Number of Shares
• Number of Follows
• Number of Comments

Hint: You need to capture all users, even those who have engaged but haven't commented or vice versa.

Example Output: