Understanding the Limitations of SQL Subqueries and GROUP BY Clause: A Practical Approach to Resolving Errors and Achieving Desired Results