海淀2016年成交量前20小区：

海淀2016年成交单价最高前10小区：

海淀2016年成交单价最低前10小区：

更多详细数据见： 链家2016成交数据分析

分析的SQL：

1、某小区成交数据按年统计

select name,regionb, strftime(‘%Y’,sign_time) as sign_year,avg(unit_price) as unit_price,avg(total_price),avg(area) from chengjiao where unit_price <>” and unit_price>6000 group by name,regionb,sign_year having name=’荣丰2008′ order by name,sign_year asc,unit_price desc

2、北京成交数据按区统计

select name,regionb,regions,avg(unit_price) as unit_price , avg(total_price) as total_price,avg(area) as area ,count(1) as num from chengjiao where unit_price <>” and regionb=’海淀’ and sign_time>’2016-01-01 00:00:00′ group by name,regionb,regions
–having name=’当代城市家园’
order by unit_price desc
–where name = ‘小南庄社区’ and unit_price <>” order by unit_price desc

数据来源：链家二手房成交记录（2016-1-1 到2016-11-23）