Hi we are migrating postgres to Mysql, and there is some serious issues with Subqueries. Can you please help me out in this query ??

SELECT...