https://lacucinadiadine.blogspot.com/2024/02/how-to-convert-sql-scalar-subquery-to.html