首页 / 校招笔试
#
校招笔试
#249681次浏览 2506人互动
此刻你想和大家分享什么
点赞 评论 收藏
分享
10-10 20:27
西安工业大学 运维开发工程师
牛6666666__:select f.farm_name as farm_name,
c.crop_name,
c.crop_type,
round(avg(health_index), 2) as avg_health_index,
round(sum(yield_kg_per_hectare),0) as avg_yield_kg_per_hectare,
datediff(max(measurement_date), min(planting_date)) as growth_days
from crop_data cd
inner join farms f on cd.farm_id = f.farm_id
inner join crops c on cd.crop_id = c.crop_id
where cd.measurement_date between '2024-03-01' and '2024-06-30'
group by cd.crop_id, cd.farm_id,f.farm_name
having count(cd.data_id) >= 3
order by avg_health_index desc, avg_yield_kg_per_hectare desc,farm_name 点赞 评论 收藏
分享
11-08 11:45
北京航空航天大学 算法工程师 点赞 评论 收藏
分享
11-16 11:33
澳门科技大学 高等教育 点赞 评论 收藏
分享
buul:只是叫?我舍友都快骑我身上了 点赞 评论 收藏
分享
点赞 评论 收藏
分享