Exercise

Which set is missing version 1?

Each set included in the LEGO data has an associated version number. We want to understand the version we are looking at to learn more about the parts that are included. Before doing that, we should confirm that there aren't any sets that are missing a particular version.

Let's start by looking at the first version of each set to see if there are any sets that don't include a first version.

Instructions

100 XP
  • Use filter() to extract version 1 from the inventories table; save the filter to version_1_inventories.
  • Use anti_join to combine version_1_inventories with sets to determine which set is missing a version 1.