Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Old vs New Movies
Task
Swipe to show code editor
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.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 1. Chapter 2
Old vs New Movies
Task
Swipe to show code editor
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.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 1. Chapter 2
Switch to desktop for real-world practiceContinue from where you are using one of the options below