Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE person_name ( pid, f_name, l_name ) AS
SELECT 1, 'Alice', 'Abbott' FROM DUAL;
1 rows affected

CREATE TABLE member  ( pid, enroll_date ) AS
SELECT 1, DATE '1970-01-01' FROM DUAL;
1 rows affected

CREATE TABLE borrow_details ( pid, date_borrowed ) AS
SELECT 1, DATE '2020-04-19' + LEVEL
FROM   DUAL
CONNECT BY LEVEL <= 6;
6 rows affected

SELECT MAX( PN.F_NAME ) AS F_NAME,
       MAX( PN.L_NAME ) AS L_NAME,
       MAX( M.ENROLL_DATE ) AS ENROLL_DATE,
       TRUNC( BD.DATE_BORROWED, 'IW' ) AS monday_of_iso_week,
       COUNT(*) AS BORROWED_COUNT
FROM   PERSON_NAME PN
       INNER JOIN MEMBER M
       ON ( PN.PID = M.PID )
       INNER JOIN BORROW_DETAILS BD
       ON ( M.PID = BD.PID )
GROUP BY
       PN.PID,
       TRUNC( BD.DATE_BORROWED, 'IW' )
HAVING COUNT(*) > 5
ORDER BY BORROWED_COUNT DESC;


F_NAME
L_NAME
ENROLL_DATE
MONDAY_OF_ISO_WEEK
BORROWED_COUNT


Alice
Abbott
01-JAN-70
20-APR-20
6