# Netflix Genre Ratings SQL Interview Question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3080/netflix-genre-ratings
Source observed: 2026-11-04T23:34:26.656Z
Last checked: 2026-11-04T23:34:26.656+00:00
Indexed: 2026-11-06T15:56:22.755+00:00

---

# Netflix Genre Ratings

**Medium · Coding · SQL**

## What we provide

We provide interview-practice questions and an interactive coding environment through Aced, formerly Exponent. This SQL question asks you to calculate both an individual movie's average rating and the average rating for that movie's genre.

The question is marked as having been last asked 3 years ago. Detailed company statistics require an [upgrade](https://www.aced.io/upgrade?src=questions). You can [sign up to run code](https://www.aced.io/signup?src=lesson). No community answers have been contributed yet.

## Scenario

Netflix is described as a popular streaming platform offering movies across multiple genres. Users rate movies they have watched. The task uses those ratings to support content recommendation and analysis.

## Tables

### `movie`

| Column | Type |
| --- | --- |
| `movie_id` | integer |
| `title` | string |
| `genre` | string |

### `rating`

| Column | Type |
| --- | --- |
| `user_id` | integer |
| `movie_id` | string |
| `rating` | integer |

## Task requirements

Write a SQL query that returns one table listing each movie with:

- `title`: the movie title
- `avg_rating`: the movie's average rating
- `genre_rating`: the average rating of its genre

Order the results by `title` and round both rating values to **1 decimal place**.

## Practice controls

The question includes separate **Question**, **Solution**, and **Community** tabs, an SQL editor, output and test-results tabs, a console, an option selector, and an editor/share panel. The solution and executable environment require the relevant account access; the available action is [Sign up to run code](https://www.aced.io/signup?src=lesson).

[Return to all questions](https://www.aced.io/questions)

## Aced learning areas

Our available learning areas include [Product Management](https://www.aced.io/courses/pm?src=nav), [Forward Deployed](https://www.aced.io/courses/forward-deployed-engineering?src=nav), [Engineering Management](https://www.aced.io/courses/engineering-management?src=nav), [Software Engineering](https://www.aced.io/courses/software-engineering?src=nav), [System Design](https://www.aced.io/courses/system-design-interviews?src=nav), [Data Science](https://www.aced.io/courses/data-science?src=nav), [Machine Learning](https://www.aced.io/courses/ml-engineer?src=nav), and [Data Engineering](https://www.aced.io/courses/data-engineering?src=nav). We also offer [Loops](https://www.aced.io/guides?src=nav), [Experiences](https://www.aced.io/experiences?src=nav), [Practice](https://www.aced.io/practice?src=nav), and [Coaching](https://www.aced.io/coaching?src=nav).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3080%2Fnetflix-genre-ratings&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3080%2Fnetflix-genre-ratings). Opening a form does not execute a tool.