select year(bu_regdate) regdate_year, count(bu_id) count_num, max(bu_price) max_price, min(bu_price) min_price, avg(bu_price/bu_monopoly_area * 3.3) avg_tsubo from bukkened_sub where bu_type1 = '3' and bu_type2 = '2' and bu_full_address like '¿Ʒ%' and bu_regdate > '2014-01-01' group by regdate_year order by bu_address1, bu_address2, bu_address3-noUnknown column 'bu_full_address' in 'where clause'