Pages carried home

Problem

The librarian wants to know who hauls the most: how many pages each member has carried home. A book that goes out twice gets carried twice: if someone borrows "The Lighthouse" a second time, its 210 pages count again. And it makes no difference whether the book is back or still out.

Show the member, how many loans they have, how many pages those add up to, and the average pages per loan, rounded to 1 decimal, in that order. Whoever has carried the most pages goes first; ties go alphabetically.

What it has to return

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

SELECT l.member, b.pages
FROM loans l
JOIN books b
  ON l.book_id = b.id