query_house.fmt 204 B

123456
  1. select
  2. u.houses as houses,
  3. avg(u.${priceName}) as price
  4. from ${tableName} u left join db_price_community pc on u.houses=pc.houses
  5. where pc.houses is null and u.houses is not null
  6. group by u.houses