SQLab
LearnPracticeProblemsArenaLeaderboard

SQLab

Practice

Mission 7 / 8

Joining tables

join · count · group by

The medicine table holds the category number, but a customer wants a name, not a number. Linking two tables by their keys is called a `join`.

A medicine and its category

Next to each medicine’s name show the name of its category (dori_nomi, kategoriya_nomi).

Preparing the database…