Creators Ahead of Their Mentors

A streaming studio pairs developing creators with more experienced mentors and tracks an engagement score for every creator.

Table: studio_creators

+------------------+--------------+
| Column Name      | Type         |
+------------------+--------------+
| creator_id       | integer      |
| creator_name     | varchar(255) |
| engagement_score | integer      |
| genre_id         | integer      |
| mentor_id        | integer      |
+------------------+--------------+
+------------------+--------------+
| Column Name      | Type         |
+------------------+--------------+
| creator_id       | integer      |
| creator_name     | varchar(255) |
| engagement_score | integer      |
| genre_id         | integer      |
| mentor_id        | integer      |
+------------------+--------------+

creator_id is the primary key. mentor_id references the creator_id of the creator's direct mentor. It is NULL for creators without a mentor. Some rows may contain a mentor_id that is not present in the table.

Find every creator whose engagement_score is strictly greater than the score of their direct mentor.

Return creator_id and creator_name, ordered by creator_id from lowest to highest. Creators without a matching mentor row must not be returned. Compare each creator only with their direct mentor, not with earlier mentors in the chain.

Output

+--------------+--------------+
| Column Name  | Type         |
+--------------+--------------+
| creator_id   | integer      |
| creator_name | varchar(255) |
+--------------+--------------+
+--------------+--------------+
| Column Name  | Type         |
+--------------+--------------+
| creator_id   | integer      |
| creator_name | varchar(255) |
+--------------+--------------+

Example

Input: studio_creators

+------------+--------------+------------------+----------+-----------+
| creator_id | creator_name | engagement_score | genre_id | mentor_id |
+------------+--------------+------------------+----------+-----------+
| 1          | Mira         | 380              | 1        | 6         |
| 2          | Leon         | 223              | 1        | 7         |
| 3          | Sora         | 700              | 1        | 8         |
| 4          | Theo         | 680              | 2        | 9         |
| 5          | Nia          | 175              | 1        | 11        |
| 6          | Arlo         | 1300             | 3        | NULL      |
| 7          | Ivy          | 1250             | 3        | NULL      |
| 8          | Rowan        | 680              | 2        | NULL      |
+------------+--------------+------------------+----------+-----------+
+------------+--------------+------------------+----------+-----------+
| creator_id | creator_name | engagement_score | genre_id | mentor_id |
+------------+--------------+------------------+----------+-----------+
| 1          | Mira         | 380              | 1        | 6         |
| 2          | Leon         | 223              | 1        | 7         |
| 3          | Sora         | 700              | 1        | 8         |
| 4          | Theo         | 680              | 2        | 9         |
| 5          | Nia          | 175              | 1        | 11        |
| 6          | Arlo         | 1300             | 3        | NULL      |
| 7          | Ivy          | 1250             | 3        | NULL      |
| 8          | Rowan        | 680              | 2        | NULL      |
+------------+--------------+------------------+----------+-----------+

Output:

+------------+--------------+
| creator_id | creator_name |
+------------+--------------+
| 3          | Sora         |
+------------+--------------+
+------------+--------------+
| creator_id | creator_name |
+------------+--------------+
| 3          | Sora         |
+------------+--------------+

Explanation: Sora's score of 700 is greater than direct mentor Rowan's score of 680. Theo and Nia reference mentor IDs that do not exist in the table, so they are excluded. The remaining creators either have no mentor or do not exceed their mentor's score.