本文深入探讨了SQL聚合查询在酒店业务数据分析中的应用，通过使用日期差和分组函数，实现了对酒店入住时间、离店时间、总天数和收入的高效计算。同时，结合酒店预订状态，提供了详细的日期预估查询，为酒店管理者提供决策支持。
select times,R.name,date,indate,outdate,money,predate
from (select count(*) as times,
name,
sum(datediff(day,indate,outdate))as date,
min(indate)as indate,
max(outdate) as outdate,
sum(datediff(day,indate,outdate)*money) as money
from hotel a
where state='O'
group by name) R
left join
(select name,max(predate) as predate from hotel b
where state='P'
group by name) S
on R.name=S.name
from (select count(*) as times,
name,
sum(datediff(day,indate,outdate))as date,
min(indate)as indate,
max(outdate) as outdate,
sum(datediff(day,indate,outdate)*money) as money
from hotel a
where state='O'
group by name) R
left join
(select name,max(predate) as predate from hotel b
where state='P'
group by name) S
on R.name=S.name
扫一扫
8976
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
