SQL select count(*) inside an inner join

expected output Example

f) Display all members who have had more than 2 book loans. (The numbers of loans taken must appear before each full_name[member_TABLE] of the member)

SELECT m.Full_name, l.Membership_ID, COUNT (*) AS '6'
    FROM Member m
    INNER JOIN Loan l ON l.Membership_ID = m.Membership_ID
    GROUP BY m.full_name