BigQuery - Daily Rate From Monthly Rate Based on Days In Month

Using the given MonthlyAmount and a date MonthDate inside the month you want to calculate for, get the daily rate based on the number of days in the month.

e.g.
January and February will give different results

SELECT
  <MonthlyAmount> / EXTRACT(DAY FROM LAST_DAY(<MonthDate>, MONTH))