**# EXAMPLE TEMPORARY TABLES:**

CREATE TEMPORARY TABLE bank.loan_and_account
                      -- A temporary table is a base table that is not stored 
                      -- in the database but instead exists only while the database 
                      -- session in which it was created is active.
SELECT
      l.loan_id,
      l.account_id,
      l.amount,
      a.district_id
FROM bank.loan l
JOIN bank.account A USING(account_id);