Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Directors Income | Join Data
Practice SQL with Cinema Database
course content

Kursinnhold

Practice SQL with Cinema Database

Practice SQL with Cinema Database

1. Aggregating Data
2. Ordering Data
3. Join Data

book
Directors Income

Oppgave

Swipe to start coding

Create a list of directors and their income from movies. For each director, count the total sum of money he/she earned from his/her movies. Then sort directors from by this income in descending order. Assign columns full_name and income.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 5
toggle bottom row

book
Directors Income

Oppgave

Swipe to start coding

Create a list of directors and their income from movies. For each director, count the total sum of money he/she earned from his/her movies. Then sort directors from by this income in descending order. Assign columns full_name and income.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 5
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt