Analyze video flags and reviews with SQL

Below is the data model used by the YouTube Trust & Safety team to keep track of who reported which upload and what the moderation reviewers later decided. Write standard SQL for each of the four requests at the end. Schema: Users(user_id, first_name, last_name) — user_id is the primary key. Videos(video_id, title) — video_id is the primary key. Flags(flag_id, user_id, video_id, flagged_at) — flag_id is the primary key; user_id references Users.user_id, video_id references…