复杂的查询就只能用这么难看的句法写吗

?select minup.ip,minup.pro,minup.tup,maxup.tup,maxup.tup-minup.tup from
?(select ip,pro,tup from audit_flow f1
where `date`=(
select max(`date`) from audit_flow where ip=f1.ip and pro=f1.pro)) as maxup
?inner join?? (
select ip,pro,tup from audit_flow f1 where `date`=(
select min(`date`) from audit_flow where ip=f1.ip and pro=f1.pro)) as minup? on minup.ip=maxup.ip and minup.pro=maxup.pro;

?

数了一下，一共有6个Select语句，SQL原来都是把简单问题复杂化