Read an entity relationship diagram

The information you need is sometimes split across multiple tables in the database.

What is the most common stackoverflow tag_type? What companies have a tag of that type?

To generate a list of such companies, you'll need to join three tables together.

Reference the entity relationship diagram as needed when determining which columns to use when joining tables.

Bu egzersiz

Exploratory Data Analysis in SQL

kursunun bir parçasıdır

Kursu Görüntüle

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Count the number of tags with each type
SELECT ___, ___ AS count
  FROM ___
 -- To get the count for each type, what do you need to do?
 ___ ___ ___
 -- Order the results with the most common tag types listed first
 ___ ___ ___ ___;

Kodu Düzenle ve Çalıştır