我需要从两个查询中减去结果的帮助

奔腾的野马

DECLARE @TotalQuestions int;
DECLARE @CorrectQuestions int;
DECLARE @IncorrectQuestions int;
SELECT (
  SET CorrectQuestion = SELECT COUNT( WiningComment)
8 h( ^- G2 t* O; ?4 i; X3 K* A    FROM Threads
    WHERE WiningComment IN (SELECT CommentsID
0 ~! A6 v$ Q& ~7 y$ {. n    FROM Comments
    WHERE  UsersID=@UserID)
6 `: N7 y# E# e) as 'WinningAnswers',
, B' t6 K8 }) m! m7 H- w3 @* r(
0 ^: w. Q; O7 t    SET TotalQuestions =  SELECT COUNT(CommentsID)
, w. h7 p. p: |1 ?6 h, N$ ^    FROM  Comments
    WHERE  UsersID=@UserID
) as 'TotalAnswers'
(
) F( K/ E2 S" c. l! e  t  SELECT  (TotalQuestions-CorrectQuestions ) //I am not sure about this part!!
) as 'IncorrectQuestions'
7 D' e+ G9 X4 x0 l) [/ `我不确定最后一部分，我想从另一个子查询的结果中减去一个子查询的结果
% [! h+ U: X- @. v               
解决方案: