Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Old vs New Movies | Aggregating Data
/
Practice SQL with Cinema Database
Sektion 1. Kapitel 2
single

single

bookOld vs New Movies

Stryg for at vise menuen

Opgave

Stryg for at begynde at kode

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

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 2
single

single

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

some-alt