Queries to get you started

by_office_metro.sql

SELECT
  offices.id AS office_id,
  offices.abbr AS metro_area,
  substr (payments.date, 1, 7) AS mnth,
  SUM(payments.amount) AS amount
FROM
  payments
  INNER JOIN transactions ON transactions.id = payments.transaction_id
  INNER JOIN customers ON customers.id = transactions.customer_id
  INNER JOIN offices ON offices.id = customers.office_id
WHERE
  payments.entered = TRUE
  AND payments.date >= '2020-01-01'
GROUP BY
  mnth,
  office_id;

by_state.sql

SELECT
  students.state,
  substr (payments.date, 1, 7) AS mnth,
  SUM(payments.amount) AS amount
FROM
  payments
  INNER JOIN transactions ON transactions.id = payments.transaction_id
  INNER JOIN customers ON customers.id = transactions.customer_id
  INNER JOIN offices ON offices.id = customers.office_id
  INNER JOIN sc ON sc.customer_id = customers.id
  INNER JOIN students ON students.id = sc.student_id
WHERE
  payments.entered = TRUE
  AND payments.date >= '2020-01-01'
GROUP BY
  mnth,
  state;