1、查询某车队4月20日至4月28日某车次的订票数量。 select t.pno,sum(piaoshu) 订票数量 from [Order] o left join Ticket t on o.tno=t.tno where odate between '2010-04-20'and'2010-04-28' and t.pno='xxxx'
1、查询某车队4月20日至4月28日某车次的订票数量。 select a.aname, t.pno,sum(piaoshu) 订票数量 from [Order] o left join Ticket t on o.tno=t.tno left join Autocade a on o.ano=a.ano where odate between '2010-04-20'and'2010-04-28' and t.pno='xxxx' and a.aname='xxx' 2、查询某车队某车次定优惠票的数量 select a.aname, t.pno,sum(piaoshu) 订票数量 from [Order] o left join Ticket t on o.tno=t.tno left join Autocade a on o.ano=a.ano where t.pno='xxxx' and tstyle='s' and a.aname='xxx'
select t.pno,sum(piaoshu) 订票数量
from [Order] o left join Ticket t on o.tno=t.tno
where odate between '2010-04-20'and'2010-04-28' and t.pno='xxxx'
select a.aname, t.pno,sum(piaoshu) 订票数量
from [Order] o left join Ticket t on o.tno=t.tno left join Autocade a on o.ano=a.ano
where odate between '2010-04-20'and'2010-04-28' and t.pno='xxxx' and a.aname='xxx'
2、查询某车队某车次定优惠票的数量
select a.aname, t.pno,sum(piaoshu) 订票数量
from [Order] o left join Ticket t on o.tno=t.tno left join Autocade a on o.ano=a.ano
where t.pno='xxxx' and tstyle='s' and a.aname='xxx'