SQL · LinkedIn · Medium
You are given two tables that describe members of a professional network and the videos they upload. members member_id INT (primary key) country VARCHAR join_date DATE — the UTC calendar date when the member joined. video_posts post_date DATE — the UTC calendar date when the video was uploaded. member_id INT (foreign key to members.member_id) video_length_seconds INT — the video’s duration in seconds. Relationship and assumptions: video_posts.member_id = members.member_id.…
Checking your access…