Search avg rent by postcode

Custom SQL query (hide)

select
  strftime('%Y-%m', date("Lodgement Date")) as date_month,
  Postcode,
  Bedrooms,
  ROUND(AVG([Weekly Rent]), 2) as mean_rent
from
  rentals
where
  "Bedrooms" = :bedroom_number
  and "Dwelling Type" IN ('F', 'H', 'T')
  AND Postcode = :postcode
group by
  date_month, Postcode, Bedrooms
ORDER by date_month DESC

Query parameters

bedroom_number

postcode

Edit SQL