Email Engagement Analysis: Write an SQL query to calculate the email engagement metrics. Can you simplify these two queries please.
