首页 / 校招笔试
#
校招笔试
#204490次浏览 2214人互动
此刻你想和大家分享什么
点赞 评论 收藏
分享
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 点赞 评论 收藏
分享
buul:只是叫?我舍友都快骑我身上了 点赞 评论 收藏
分享
10-26 12:06
University of Birmingham Java 点赞 评论 收藏
分享