Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Suppliers Supplying All Parts

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.