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
Learn
Courses
Projects
Tracks
Practice
Real World Projects
Quizzes & Challenges
Quizzes
Challenges
/
Practice SQL with Cinema Database

bookTwo 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

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

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

close

bookTwo Most Popular Movies

Swipe to show menu

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

some-alt