Объединить 2 запроса в 1

CREATE TABLE Publication(
    PublID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    BookTitle nvarchar(50) UNIQUE NOT NULL,
    YearOfPubl NUMERIC(4, 0) NOT NULL,
    NumberOfPages INT NOT NULL,
    Annotation ntext NULL,
    Qty INT NULL, 
);
CREATE TABLE AktSpisania_Publication(
    AktSpisID INT NOT NULL FOREIGN KEY REFERENCES AktSpisania(AktSpisID),
    PublID INT NOT NULL FOREIGN KEY REFERENCES Publication(PublID),
    PRIMARY KEY (AktSpisID, PublID),
    Qty NUMERIC(3, 0) NOT NULL
);
 
CREATE TABLE AktPriema_Publication(
    AktPrID INT NOT NULL FOREIGN KEY REFERENCES AktPriema(AktPrID),
    PublID INT NOT NULL FOREIGN KEY REFERENCES Publication(PublID),
    PRIMARY KEY (AktPrID, PublID),
    Qty NUMERIC(3, 0) NOT NULL
);

SELECT
 P.BookTitle,
 P.Qty,
 SUM(Sp.Qty) AS 'Количество списанных'
FROM [NewDB].[dbo].[Publication] AS P 
JOIN [NewDB].[dbo].[AktSpisania_Publication] AS Sp
ON P.PublID=Sp.PublID 
GROUP BY
 P.PublID,
 P.BookTitle,
 P.Qty

SELECT 
 P.BookTitle,
 P.Qty,
 ISNULL(SUM (Pr.Qty),0) AS 'Количество принятых',
 ISNULL(SUM(Sp.Qty),0) AS 'Количество списанных'
FROM [NewDB].[dbo].[Publication] AS P 
JOIN [NewDB].[dbo].[AktPriema_Publication] AS Pr
ON P.PublID=Pr.PublID
LEFT JOIN [NewDB].[dbo].[AktSpisania_Publication] AS Sp
ON P.PublID=Sp.PublID 
GROUP BY
 P.PublID,
 P.BookTitle,
 P.Qty;

SELECT 
 P.BookTitle,
 P.Qty,
 SUM (Pr.Qty) AS 'Количество принятых'
FROM [NewDB].[dbo].[Publication] AS P 
JOIN [NewDB].[dbo].[AktPriema_Publication] AS Pr
ON P.PublID=Pr.PublID
LEFT JOIN (
SELECT
 P1.BookTitle,
 P1.Qty,
ISNULL(SUM(Sp.Qty),0) AS 'Количество списанных'
FROM [NewDB].[dbo].[Publication] AS P1 
JOIN [NewDB].[dbo].[AktSpisania_Publication] AS Sp
ON P1.PublID=Sp.PublID 
GROUP BY
 P1.BookTitle,
 P1.Qty) s
 ON P.BookTitle=s.BookTitle  
 
GROUP BY
 P.BookTitle,
 P.Qty;