Top Titles By User Ratings
top_titles_by_user_ratingsRank books by average user rating or rating count from a 4,154-user panel. Set direction and minimum ratings to find the best- or worst-liked titles.
Instructions
Best- or worst-liked titles among the 4,154 users in user_ratings.
Stays entirely inside user_ratings -- no join, so no title-matching loss. These are the opinions of a small user panel, not the books table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Titles to return, max 100. | |
| order_by | No | 'avg_user_rating' to rank by score, 'n_user_ratings' to rank by how many of these users rated it. | avg_user_rating |
| direction | No | 'desc' for best-liked first, 'asc' for worst-liked first. | desc |
| min_ratings | No | Minimum number of user ratings a title must have to be ranked. Floor 1. With only 4,154 users, titles thin out fast -- keep this well above 1 for a meaningful ranking. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||