Session Ready
Exercise

What colors are included in at least one set?

Besides comparing two sets directly, you could also use a filtering join like semi_join to find out which colors ever appear in any inventory part. Some of the colors could be optional, meaning they aren't included in any sets.

The inventory_parts and colors tables have been preloaded for you.

Instructions
100 XP
  • Use the inventory_parts table to find the colors that are included in at least one set.