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

Opgave

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

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 3. Kapitel 6
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

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

Stryg for at vise menuen

Opgave

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 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 3. Kapitel 6
single

single

some-alt