https://stiellledm310.blogspot.com/2024/11/convert-sql-query-with-subquery-to.html