本文记录了如何使用SQL查询来统计特定地区和年份的农作物种植总面积，详细探讨了涉及的数据表和关键查询技巧。
根据数据表统计某地某年农作物种植面积
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&#
最低0.47元/天 解锁文章
扫一扫
815
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
