Write a query to find the top 10 most watched anime series from a dataset.
Use the provided anime_series and watch_events tables. Calculate total watches per series, include series with no valid watch events, and return fewer than 10 rows only if fewer than 10 series exist.
series_title and total_watchestotal_watches descending, then series_title ascending for ties| Column | Type | Description |
|---|---|---|
| series_idPK | INTEGER | Unique identifier for an anime series |
| series_title | VARCHAR(200) | Anime series title |
| Column | Type | Description |
|---|---|---|
| event_idPK | INTEGER | Unique identifier for a watch event |
| series_id | INTEGER | Referenced anime series identifier |
| watch_count | INTEGER | Number of watches represented by the event |