**# EXAMPLE SQL CORRELATED SUB-QUERIES:**

SELECT 
      *
FROM bank.loan l1
WHERE amount > (SELECT
                      avg(amount)
				FROM bank.loan l2
                WHERE l1.status = l2.status
                -- A correlated subquery is a subquery that refers to a column of 
                -- a table that is not in its FROM clause.
                )
ORDER BY amount DESC
LIMIT 10;