Learn

Platform

For Business

Pricing

Resources

/

#5

Movie Metrics

Movie Metrics

Your Objective

Your Objective

You've been given a table of Netflix users and another with their viewing activity, including the movie name, date started, and whether they finished it.

Your task is to engineer these new features for each user, based on their activity:

  • Date from the first movie they finished

  • Name of the first movie they finished

  • Date from the last movie they finished

  • Name of the last movie they finished

  • Movies started

  • Movies finished

Example:

Submit your solution

How many users have "Fight Club" as the last film they've seen?

Watch the solution video & tutorial

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.