Suppliers (sid:integer, sname: string, address: string)
Parts (pid: integer, pname: string, color: string)
Catalog (sid: integer, pid: integer, cost: real)

Write the following queries in SQL:

Find the pnames of parts for which there is some supplier.

SELECT P.pname
FROM Parts P, Catalog C
WHERE C.pid = P.pid