题目1:客户活跃度
有一个表VUA,里面有ID,DATE两个变量,
要选出在3.5号出现的用户ID,在后三天3.21-3.23出现的总次数统计
建表语句:
create table vua
(
id varchar(20) not null,
date datetime
);
insert into vua values('1','3-5');
insert into vua values('1','3-6');
insert into vua values('1','3-7');
insert into vua values('1','3-8');
insert into vua values('2','3-5');
insert into vua values('2','3-6');
insert into vua values('2','3-8');
insert into vua values('3','3-5');
insert into vua values('3','3-6');
insert into vua values('3','3-7');
insert into vua values('4','3-5');
insert into vua values