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

Key Concepts:

• SQL Query
• Subquery
• Meeting Rooms
• Meeting Duration
• Logical Error

Problem Statement:

The challenge involves identifying a potential error within a SQL query designed to find meeting rooms where all scheduled meetings exceed 30 minutes in duration. The core issue lies within the subquery's logic, which is not functioning as intended.

Task:

The task is to analyze the provided SQL code, identify the flaw in the subquery, and propose a solution. The solution should be shared in the comments section.

Expected Outcome:

The expected outcome is a corrected SQL query that accurately identifies meeting rooms meeting the specified criteria (all meetings longer than 30 minutes).