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