Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn 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

Task

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.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 6
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

close

bookChallenge: Student Performance Dashboard

Swipe to show menu

Task

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.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 6
single

single

some-alt