Kursusindhold
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Old vs New Movies
Opgave
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 2
Old vs New Movies
Opgave
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 2
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder