1Get supplier names and the quantity of parts suppliedSoluti

1.Get supplier names and the quantity of parts supplied.

Solution

Here is the query

select sname and qty
from s,sp
where s.s# = sp.s#

EXPLANATION:

selecting name from supplier table and quantity from SP table where condition is id from SP and Supplier table should match.