sql 面积求和笔记

最新推荐文章于 2024-01-05 09:48:41 发布

原创最新推荐文章于 2024-01-05 09:48:41 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

sql 专栏收录该内容

3 篇文章

订阅专栏

本文记录了如何使用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' and current_year ='2017';
SELECT sum(area_num) as "2017玉米面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='1' and current_year ='2017';
SELECT sum(area_num) as "2017其他面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='2' and current_year ='2017';

SELECT sum(area_num) as "2018总面积"  from t_distribution where ad_area_code LIKE '6103%' and current_year ='2018';
SELECT sum(area_num) as "2018小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0' and current_year ='2018';
SELECT sum(area_num) as "2018玉米面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='1' and current_year ='2018';
SELECT sum(area_num) as "2018其他面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='2' and current_year ='2018';

SELECT sum(area_num) as "总面积"  from t_distribution where ad_area_code LIKE '6103%' and current_year ='2019';
SELECT sum(area_num) as "小麦面积" from t_distribution where ad_area_code LIKE '6103%' and flag ='0' and current_year ='2019';
SELECT sum(area_num) as "玉米面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='1' and current_year ='2019';
SELECT sum(area_num) as "其他面积"  from t_distribution where ad_area_code LIKE '6103%' and flag ='2' and current_year ='2019';