Learn Old vs New Movies | Aggregating Data

Section 1. Chapter 2

single

Swipe to show menu

Task

Swipe to start coding

Explore which movies have better average rating: created in the 20th or in the 21st century? Output rows with two columns: average rate and number of century. Two rows in total - for 20th and 21th century.

Name the columns avg and century.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 2

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat