medium · ~12 min
Procurement wants a directory of active suppliers from suppliers who have recorded at least one shipment in shipments.
suppliers
shipments
Write a query that returns each qualifying supplier:
supplier_id
supplier_name
country
Input contract: supplier_id is unique and non-null in suppliers; shipment_id is unique and non-null in shipments; shipments.supplier_id is a non-null foreign key to suppliers. A supplier can have zero, one, or many shipments.
shipment_id
shipments.supplier_id