text: SELECT "RealEstate2_7"."Calculation_222787466264023043" AS "Calculation_222787466264023043",   "RealEstate2_7"."Calculation_342484700263473152" AS "Calculation_342484700263473152",   "RealEstate2_7"."Date_of_Transfer" AS "Date_of_Transfer",   "RealEstate2_7"."Street" AS "Street",   AVG(CAST("RealEstate2_7"."Latitude" AS double)) AS "avg:Latitude:ok",   AVG(CAST("RealEstate2_7"."Longitude" AS double)) AS "avg:Longitude:ok",   AVG(CAST(CAST("RealEstate2_7"."Price" AS BIGINT) AS double)) AS "avg:Price:ok",   MIN("RealEstate2_7"."Date_of_Transfer") AS "max:Date_of_Transfer:ok",   "RealEstate2_7"."town/city url string (copy)" AS "town/city url string (copy)" FROM "RealEstate2_7" WHERE ((locate('THE BISHOPS AVENUE',"RealEstate2_7"."Street")>0) AND ("RealEstate2_7"."Date_of_Transfer" >= cast('1996-01-01' as DATE)) AND ("RealEstate2_7"."Date_of_Transfer" < cast('2019-01-01' as DATE)) AND ("RealEstate2_7"."County" = 'CITY OF NOTTINGHAM') AND ("RealEstate2_7"."Postcode_District" = 'N2')) GROUP BY "RealEstate2_7"."Calculation_222787466264023043",   "RealEstate2_7"."Calculation_342484700263473152",   "RealEstate2_7"."Date_of_Transfer",   "RealEstate2_7"."Street",   "RealEstate2_7"."town/city url string (copy)";
  