根据数据表统计某地某年农作物种植面积
SELECT *from t_distribution ;
SELECT sum(area_num) as "2016总面积" from t_distribution where ad_area_code LIKE '6103%' and current_year ='2016';
SELECT sum(area_num) as "2016小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0' and current_year ='2016';
SELECT sum(area_num) as "2016玉米面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='1' and current_year ='2016';
SELECT sum(area_num) as "2016其他面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='2' and current_year ='2016';
SELECT sum(area_num) as "2017总面积" from t_distribution where ad_area_code LIKE '6103%' and current_year ='2017';
SELECT sum(area_num) as "2017小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0&#