SQL 查询小说书籍信息：作者、章节数、字数、更新时间

SELECT nb.*, na.pen_name AS author_name, COUNT(DISTINCT nc.id) AS chapterCount, SUM(nc.word_count) AS totalWords, MAX(nc.create_time) AS lastUpdateTime FROM novel_books nb LEFT JOIN novel_author na ON nb.author_id = na.id LEFT JOIN novel_chapter nc ON nb.id = nc.book_id;