Can you spot the two issues with how we’re counting active users? Go!

Key Concepts:

• Active User Count
• SQL Query Optimization
• Data Accuracy
• Business Intelligence Reporting

Problem Statement:

The provided SQL query aims to count active users by region. However, the business team reports that the numbers generated by the query are lower than expected. The challenge is to identify two issues within the query that contribute to this discrepancy.

Challenge:

Identify two issues in the SQL query that lead to an undercounting of active users by region. Share the solutions in the comments.