求大神帮助SQL写法

把两张表的列名写出来

with
ctein
as
(
(select SUM(A.value) as aval,userid,SUBSTRING(date,1,4) as y from A group by date,userid)
),
cteout
as
(
select SUM(aval) as val,userid,y
from ctein
group by y,userid
)
select cteout.userid,cteout.y,cteout.val
from cteout,B
where cteout.userid=B.userid
and cteout.val=B.value

SELECT DISTINCT A.[date],A.useid,A.value,
(CASE A.value
WHEN (SELECT SUM(B.value) FROM B WHERE A.useid=B.useid AND A.[date]=SUBSTRING(B.[date],1,4)) THEN *一样*
ELSE *不一样*
END
) AS *区别*
FROM A