Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Two Most Popular Movies | Join Data
Practice SQL with Cinema Database

Swipe to show menu

book
Two Most Popular Movies

Task

Swipe to start coding

Find the most popular movie of the 20th century, and also the most popular movie of the 21st century (both based on total sales).

To submit the task, output two rows with columns named movie (for movie label), income (for total sales), and year.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 7
single

single

Ask AI

expand

Ask AI

ChatGPT

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

close

Awesome!

Completion rate improved to 4.55

book
Two Most Popular Movies

Task

Swipe to start coding

Find the most popular movie of the 20th century, and also the most popular movie of the 21st century (both based on total sales).

To submit the task, output two rows with columns named movie (for movie label), income (for total sales), and year.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 4.55

Swipe to show menu

some-alt