SQL TUTORIALS

Answer Key

1. Query used:
   SELECT part_num AS id, name
FROM parts
UNION
SELECT set_num AS id, name
FROM sets;
2. Query used:
   SELECT part_num
FROM parts
INTERSECT
SELECT part_num
FROM inventory_parts;
3. Query used:
   SELECT set_num
FROM sets
EXCEPT ALL
SELECT set_num
FROM inventory_sets;
4. Query used:
   SELECT name
FROM themes
UNION ALL
SELECT name
FROM sets
UNION ALL
SELECT name
FROM parts
UNION ALL
SELECT name
FROM part_categories;
5. Query used:
   SELECT set_num
FROM sets
JOIN themes ON sets.theme_id = themes.id
WHERE themes.name = 'Fire'
EXCEPT
SELECT set_num
FROM inventory_sets;