---

INNER JOIN  client USING (client_id)
    INNER JOIN buy_book USING (buy_id)
    INNER JOIN book USING (book_id)
GROUP BY buy_book.buy_id
ORDER BY 1;