SELECT
vname,
vzip
FROM
product,
vendor,
recruit
WHERE
recruit.vid = vendor.vid
AND recruit.pid = product.pid
AND product.pname = 'iPhone 7';
SELECT
vname,
vzip
FROM
product,
vendor,
recruit
WHERE
recruit.vid = vendor.vid
AND recruit.pid = product.pid
AND product.pname = 'iPhone 7';