Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.学ぶ Challenge: FULL JOIN Usage | Section
Intermediate SQL
セクション 1. 章 21
single

single

bookChallenge: FULL JOIN Usage

メニューを表示するにはスワイプしてください

In this chapter, you'll learn how to use a different type of table join. Unlike the previous chapters where you could use the same JOIN, this time you'll need to apply a specific one.

タスク

スワイプしてコーディングを開始

Write a query to retrieve a list of all courses and students, including those courses with no registered students and those students who are not registered for any course.

To accomplish this, you will need to use a specific type of join. Also, retrieve the columns in the exact order as specified:

courses.course_id,
courses.course_name,
courses.description,
enrollments.student_name,
enrollments.enrollment_date

Additionally, sort the result by the course_id column. Good luck!

Brief Instructions

  • Retrieve the necessary columns from the courses table.
  • Use a FULL JOIN to join the enrollments table.
  • The common column for both tables is courses.course_id = enrollments.course_id.
  • Sort the results by courses.course_id.

解答

Switch to desktop実践的な練習のためにデスクトップに切り替える下記のオプションのいずれかを利用して、現在の場所から続行する
すべて明確でしたか？

どのように改善できますか？

フィードバックありがとうございます！

セクション 1. 章 21
single

single

AIに質問する

expand

AIに質問する

ChatGPT

何でも質問するか、提案された質問の1つを試してチャットを始めてください

some-alt