Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Two Most Popular Movies
Task
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
.
Task
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
.
Everything was clear?
Two Most Popular Movies
Task
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
.
Task
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
.
Everything was clear?
Two Most Popular Movies
Task
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
.
Task
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
.
Everything was clear?
Task
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
.