Suppliers Supplying All Parts
Hard
Relational Division
Return the suppliers that supply every part listed in Parts. Order by supplier.
Table schema
Parts(id INT PRIMARY KEY)
Supplies(supplier VARCHAR(20), part_id INT)Sample data
Parts: 1, 2, 3
Supplies:
supplier | part_id
S1 | 1
S1 | 2
S1 | 3
S2 | 1
S2 | 2
S3 | 1
S3 | 2
S3 | 3
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.