https://camera-optical-zoom.blogspot.com/2023/04/how-to-convert-sql-scalar-subquery-to.html