The code below works well but displays the results in two different tables. I would like to display the stored procedure result in one table.

```sql
USE [LSM2]
GO

-- StoredProcedure [dbo].[Proc_TotalBooks]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Proc_TotalBooks]
AS
BEGIN
    SELECT COUNT([Book ID]) AS TotalBooks FROM BookRegistration;
    SELECT COUNT([Book ID]) AS BorrowedBooks FROM Borrowing;    
END

```

![enter image description here](https://i.stack.imgur.com/m438X.png)