像这样试试...

Select
    m.MEMBER_ID,
    m.LAST_NAME,
    m.FIRST_NAME,
    r.TITLE_ID,
    Count(r.TITLE_ID)  "BORROWED"
FROM
    MEMBER m
INNER JOIN 
    RENTAL r ON(r.MEMBER_ID = m.MEMBER_ID) 
GROUP BY
    m.MEMBER_ID,
    m.LAST_NAME,
    m.FIRST_NAME,
    r.TITLE_ID

如果您链接数据表，您仍然可以使用汇总函数，例如Count（），并依未汇总的数据行来群组数据。这样应该可以完成工作。此致...

在Oracle 12中，可以使用LATERAL联接：

SELECT m.member_id, 
       m.last_name,
       m.first_name,
       r.num_rentals
FROM   member m
       CROSS JOIN LATERAL (
         SELECT title_id,
                COUNT(*) AS num_rentals
         FROM   rental r
         WHERE  m.member_id = r.member_id
         GROUP BY
                r.title_id
       ) r

或者您可以使用LEFT OUTER JOIN：

SELECT m.member_id, 
       m.last_name,
       m.first_name,
       r.title_id,
       COALESCE(r.num_rentals, 0) AS num_rentals
FROM   member m
       LEFT OUTER JOIN (
         SELECT member_id,
                title_id,
                COUNT(*) AS num_rentals
         FROM   rental
         GROUP BY
                member_id,
                title_id
       ) r
       ON (m.member_id = r.member_id)

或者，将聚合移动到外部查询：

SELECT m.member_id, 
       MAX(m.last_name) AS last_name,
       MAX(m.first_name) AS first_name,
       r.title_id,
       COUNT(r.title_id) AS num_rentals
FROM   member m
       LEFT OUTER JOIN rental r
       ON (m.member_id = r.member_id)
GROUP BY
       -- group by the primary key
       m.member_id,
       r.title_id

如果您使用INNER JOIN，则当成员没有借阅任何书籍时，您将不会得到任何结果。
fiddle