Netflix's catalogue team shows the first genre as the "main" one and the last as a secondary tag. They want to check titles that have exactly three genres.
For titles whose genres list has exactly three genres (like 'Drama;Crime;Thriller'), show the first and the last genre.
Expected output
Example of the shape (made-up values):
| title_id | title | first_genre | last_genre |
|---|---|---|---|
| 17 | Paper Planet | Sci-Fi | Family |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.