https://www.oracleerpappsguide.com/2011/11/subqueries-in-sql.html