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.

-- Count the number of tags with each type

SELECT type, count(*) AS count

FROM tag_type

GROUP BY type

ORDER BY count ASC

*

Yarik's Notepad