text: SELECT "RealEstate2_7"."Calculation_222787466264023043" AS "Calculation_222787466264023043",   AVG(CAST(CAST("RealEstate2_7"."Price" AS SIGNED) AS double)) AS "avg:Price:ok" FROM "RealEstate2_7" WHERE ((locate('THE BISHOPS AVENUE',"RealEstate2_7"."Street")>0) AND ("RealEstate2_7"."County" = 'GREATER LONDON') 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"."Postcode_District" = 'N2') AND ("RealEstate2_7"."Property_Type" <> 'O')) GROUP BY "RealEstate2_7"."Calculation_222787466264023043";
  