Lego

SELECT 
	public.inventory_parts.*,
	public.parts.name as part_name,
	public.part_categories.name as part_category_name
FROM 
	public.inventory_parts
	LEFT JOIN public.parts USING(part_num)
	LEFT JOIN public.part_categories ON part_cat_id = id
LIMIT 100

SELECT 
	set_num,
	SUM(num_parts) as total_num_parts,
	SUM(public.inventory_parts.quantity) as total_parts_quantity
FROM 
	public.sets
	LEFT JOIN public.inventory_sets USING(set_num)
	LEFT JOIN public.inventory_parts USING(inventory_id)
GROUP BY set_num

-- Explore the data in the table
SELECT
*
FROM public.inventories
LEFT JOIN public.inventory_sets USING(set_num)