Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Apprendre Challenge: Classes Without Teachers | Handling NULLs, Performance, and Real-World Join Scenarios
SQL Joins in Depth

bookChallenge: Classes Without Teachers

Tâche

Swipe to start coding

Write a query to produce a list of all classes along with their assigned teacher names. If a class does not have a teacher assigned, display 'Unassigned' as the teacher name instead.

  • Select the class ID and class name from the classes table.
  • Include the teacher's name for each class using a join with the teachers table.
  • For classes without an assigned teacher, display 'Unassigned' as the teacher name.

Solution

Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 7
single

single

Demandez à l'IA

expand

Demandez à l'IA

ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

close

bookChallenge: Classes Without Teachers

Glissez pour afficher le menu

Tâche

Swipe to start coding

Write a query to produce a list of all classes along with their assigned teacher names. If a class does not have a teacher assigned, display 'Unassigned' as the teacher name instead.

  • Select the class ID and class name from the classes table.
  • Include the teacher's name for each class using a join with the teachers table.
  • For classes without an assigned teacher, display 'Unassigned' as the teacher name.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 7
single

single

some-alt