Analyze video posting activity

You are given two tables about members and video uploads. Table 1: `video_posts` - `post_date` DATE — UTC calendar date of the upload - `member_id` INT - `video_length_seconds` INT Table 2: `members` - `member_id` INT - `country` STRING - `join_date` DATE — UTC calendar date when the member joined Relationship: - `video_posts.member_id = members.member_id` Assumptions: - Each row in `video_posts` represents one uploaded video. - Dates are compared as UTC calendar dates. - If a member uploaded multiple videos on their earliest upload date, that date is still considered the member's first video date. Write SQL (and optionally Python for part 2) for the following: 1. How many members posted their first-ever video on the same calendar date that they joined the platform? - Output column: `members_first_video_on_join_date` 2. Compare total uploaded videos by US members versus non-US members. - Define `member_region = 'US'` when `country = 'usa'`, otherwise `member_region = 'Non-US'` - Output columns: `member_region, total_video_posts` 3. For each country, count how many distinct members have posted at least one video longer than 60 seconds. - Output columns: `country, members_with_video_over_60s`