Number int,
BuyDate datetime,
Buymoney money
)
insert into order_information values(1,'2015-01-01',100)
insert into order_information values(2,'2015-08-11',200)
insert into order_information values(3,'2015-08-12',300)
insert into order_information values(4,'2015-08-13',400)
insert into order_information values(5,'2015-08-14',500)
insert into order_information values(6,'2016-04-25',600)
insert into order_information values(7,'2015-01-01',700)
select BuyDate as DateT,sum(Buymoney) as sumMoney from order_information where convert(varchar(8),BuyDate,112)<='20160425' and convert(varchar(8),BuyDate,112)>='20150101' group by BuyDate
--点击产品表
create table Visitor_click_product(
Numberid int,
DateT datetime,
ActionA varchar(100)
)
--点击购买表
create table Visitor_click_buy(
Numberid int,
DateT datetime,
ActionA varchar(100)
)
--点击付款表
create table Visitor_click_pay(
Numberid int,
DateT datetime,
Ordernum int,
ActionA varchar(100)
)
--插入用户点击产品数据
insert into Visitor_click_product values(1,'2017-08-20','点击产品')
insert into Visitor_click_product values(2,'2017-08-21','点击产品')
insert into Visitor_click_product values(3,'2017-08-20','点击产品')
insert into Visitor_click_product values(4,'2017-08-20','点击产品')
--插入用户点击购买数据
insert into Visitor_click_buy values(1,'2017-08-20','点击购买')
insert into Visitor_click_buy values(2,'2017-08-21','点击购买')
insert into Visitor_click_buy values(3,'2017-08-20','点击购买')
insert into Visitor_click_buy values(4,'2017-08-20','点击购买')
--插入用户点击付款数据
insert into Visitor_click_pay values(1,'2017-08-20','点击付款')
insert into Visitor_click_pay values(2,'2017-08-21','点击付款')
insert into Visitor_click_pay values(3,'2017-08-20','点击付款')
insert into Visitor_click_pay values(4,'2017-08-20','点击付款')
select pay.DateT as 日期,SUM(pro.Numberid) as 当天点击人数,SUM(buy.Numberid) as 当天点击产品点击购买人数,SUM(pay.Numberid)
as 当天点击购买按钮付款人数 from Visitor_click_product pro ,Visitor_click_buy buy, Visitor_click_pay pay where pro.Numberid = buy.Numberid and buy.Numberid = pay.Numberid group by pay.DateT