https://codelife.javelupango.com/ms-sql/use-sub-query-in-sql-query/
use Sub-Query in SQL Query