Написать функцию, которая возвращает список библиотекарей и количество выданных каждым из них книг

GO
CREATE FUNCTION LibsList()
RETURNS TABLE 
AS RETURN (SELECT l.FirstName+' '+l.LastName AS 'Библиотекарь', COUNT(b.Id) AS 'Кол-во'
FROM Libs l
JOIN S_Cards sc ON sc.Id_Lib=l.Id
JOIN T_Cards tc ON tc.Id_Lib=l.Id
JOIN Books b ON tc.Id_Book=b.Id AND sc.Id_Book=b.Id
GROUP BY l.FirstName,l.LastName)
GO

GO
CREATE FUNCTION LibsList()
RETURNS TABLE 
AS RETURN (SELECT l.FirstName+' '+l.LastName AS 'Библиотекарь', COUNT(b.Id) AS 'Кол-во'
FROM Libs l
JOIN S_Cards sc ON sc.Id_Lib=l.Id
JOIN Books b ON sc.Id_Book=b.Id 
GROUP BY l.FirstName,l.LastName)
GO

SELECT
 *
FROM
 Libs l
 JOIN S_Cards sc ON sc.Id_Lib=l.Id
 JOIN T_Cards tc ON tc.Id_Lib=l.Id
WHERE
 l.Id = 1;

GO
CREATE FUNCTION LibsList()
RETURNS TABLE 
AS RETURN (SELECT l.FirstName+' '+l.LastName AS 'Библиотекарь', COUNT(b.Id) AS 'Кол-во'
FROM Libs l, S_Cards sc, T_Cards tc, Books b
WHERE sc.Id_Lib=l.Id AND tc.Id_Lib=l.Id AND sc.Id_Book=b.Id AND tc.Id_Book=b.Id
GROUP BY l.FirstName,l.LastName)
GO

GO
CREATE FUNCTION LibsList()
RETURNS TABLE 
AS RETURN (SELECT lb.Библиотекарь, SUM(lb.[Кол-во]) AS 'Кол-во выданных книг'
FROM(
SELECT l.FirstName+' '+l.LastName AS 'Библиотекарь', COUNT(b.Id) AS 'Кол-во'
FROM Libs l
JOIN S_Cards sc ON sc.Id_Lib=l.Id
JOIN Books b ON sc.Id_Book=b.Id
GROUP BY l.FirstName,l.LastName
UNION ALL
SELECT l.FirstName+' '+l.LastName AS 'Библиотекарь', COUNT(b.Id) AS 'Кол-во'
FROM Libs l
JOIN T_Cards tc ON tc.Id_Lib=l.Id
JOIN Books b ON tc.Id_Book=b.Id
GROUP BY l.FirstName,l.LastName) lb
GROUP BY lb.[Библиотекарь])
GO

go
create function GaveBooks()
returns table 
as return 
(
    Select Libs.firstname + ' ' + Libs.lastname as Librarian, Count(*) as GaveOut
    from Libs 
    join S_Cards on Libs.id = S_Cards.Id_Lib 
    join T_Cards on Libs.id = T_Cards.Id_Lib
    group by Libs.firstname + ' ' + Libs.lastname
)