Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Challenge: Student Performance Dashboard | Handling NULLs, Performance, and Real-World Join Scenarios
Practice
Projects
Quizzes & Challenges
Quizzes
Challenges
/
SQL Joins in Depth

bookChallenge: Student Performance Dashboard

Oppgave

Swipe to start coding

Create a query that produces a dashboard for student performance.

  • Join the students, classes, teachers, and grades tables.
  • Display each student's name, class name, teacher name, and the average of their grades.
  • Ensure that all students are included, even if they do not have a class, teacher, or grades.

Løsning

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 6
single

single

Spør AI

expand

Spør AI

ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

Suggested prompts:

Can you explain this in simpler terms?

What are the main points I should remember?

Can you give me an example?

close

bookChallenge: Student Performance Dashboard

Sveip for å vise menyen

Oppgave

Swipe to start coding

Create a query that produces a dashboard for student performance.

  • Join the students, classes, teachers, and grades tables.
  • Display each student's name, class name, teacher name, and the average of their grades.
  • Ensure that all students are included, even if they do not have a class, teacher, or grades.

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 6
single

single

some-alt