https://keroseneheaterreview.blogspot.com/2023/12/how-to-convert-sql-scalar-subquery-to.html