https://zoheirsoftware.com/blog/subquery-in-sql-server-database