BaşlayınÜcretsiz Başlayın

Inner Joins (II)

Here, you'll continue to practice your INNER JOIN skills. We'll use the album table as last time, but will join it to a new table - artist - which consists of two columns: artist_id and name.

Bu egzersiz

Introduction to SQL Server

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Select the album_id and title columns from album (the main source table name).
  • Select the name column from artist and alias it as artist.
  • Identify a common column between the album and artist tables and perform an inner join.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Select album_id and title from album, and name from artist
SELECT 
  ___,
  ___,
  ___ AS artist
  -- Enter the main source table name
FROM ___
  -- Perform the inner join
INNER JOIN ___ on ___.___ = ___.artist_id;
Kodu Düzenle ve Çalıştır