System Design · LinkedIn · Medium
You are asked to assess whether members located in the United States upload videos more frequently than members located outside the United States. The available data is stored in two tables. members memberid INT, primary key country VARCHAR, for example 'usa', 'uk', or 'india' join_date DATE video_posts post_date DATE memberid INT, foreign key referencing members.memberid video_length INT, measured in seconds Business question: do US members upload more videos than non-US…
Checking your access…