Practice Interview Questions
| Question | Status |
|---|---|
Display the video ID(s) that have received the most reported flags. In case of a tie, include all videos with the highest number of flags. Make sure that the reported flags were all reviewed.
user_flags table:
| Column Name | Description |
|---|---|
| video_id | Identifier of the video that was flagged |
| flag_id | The flag identifier raised for the video |
flag_review table:
| Column Name | Description |
|---|---|
| flag_id | Identifier of the raised flag |
| is_reviewed | Whether the flag was reviewed |
| reviewed_date | Date when the flag was reviewed |
| reviewed_outcome | The outcome of the review process |
| video_id |
|---|
| 1001 |
| 1002 |
Display the video ID(s) that have received the most reported flags. In case of a tie, include all videos with the highest number of flags. Make sure that the reported flags were all reviewed.
user_flags table:
| Column Name | Description |
|---|---|
| video_id | Identifier of the video that was flagged |
| flag_id | The flag identifier raised for the video |
flag_review table:
| Column Name | Description |
|---|---|
| flag_id | Identifier of the raised flag |
| is_reviewed | Whether the flag was reviewed |
| reviewed_date | Date when the flag was reviewed |
| reviewed_outcome | The outcome of the review process |
| video_id |
|---|
| 1001 |
| 1002 |