SQL高难语句

drop table tb;

create table tb(inspect_name varchar(20), vdatetime2 datetime, vtime int, jcnr varchar(20),rank varchar(2),uplj varchar(2));
insert into tb(inspect_name, vdatetime2, vtime,jcnr,rank,uplj)
select
'王','2010-01-03 00:33:52',60,'内容','A' ,'Y'union all select
'王','2010-01-03 00:33:52',67,'内容','A' ,'Y'union all select
'王','2010-01-03 12:32:50',100,'内容','B','Y' union all select
'王','2010-01-04 09:33:52',57,'内容','B' ,'Y'union all select
'王','2010-01-04 10:33:52',62,'内容','B' ,'Y'union all select
'王','2010-01-04 12:32:50',100,'内容','A','Y' union all select
'王','2010-01-09 00:33:52',60,'内容','B' ,'Y'union all select
'王','2010-01-09 00:33:52',65,'内容','B' ,'Y'union all select
'王','2010-01-09 12:32:50',130,'内容','B' ,'Y'union all select
'王','2010-01-10 00:33:52',60,'内容','B' ,'Y'union all select
'王','2010-01-10 22:33:52',65,'内容','A' ,'Y'union all select
'王','2010-01-10 12:32:50',1