Analyze Video Posting Activity

You are given two tables about user video uploads.

video_posts(post_date DATE, member_id INT, video_length INT)

• One row per uploaded video.
• video_length is measured in seconds.

members(member_id INT, country VARCHAR, join_date DATE)

• One row per platform member.

Join key: members.member_id = video_posts.member_id. Assume post_date and join_date are calendar dates in the same timezone.

Tasks:

1. Count how many members posted their first-ever video on the same date they joined the platform.
2. Compare US members vs non-US members on total video uploads. Return the total number of video posts for each group ( 'usa' vs 'non-usa' ). Include members with zero uploads in the grouping; they contribute 0 posts.
3. For each country, count how many distinct members have posted at least one video longer than 60 seconds.

Definitions:

• For task 1, a member's first video is the earliest post_date in video_posts for that member.
• If a member uploaded multiple videos on their first posting date, count that member only once.

Required output:

• Task 1: members_first_video_same_day
• Task 2: country_group, total_video_posts
• Task 3: country, num_members_with_long_video