1. For the following 3 tables:

PRODUCT(ID(PK), PNAME)

SUPPLIER(SID(PK, SNAME)

SUPPLIES(SUID(PFK), PID(PFK)) -- SUID references SUPPLIER's SID, PID references PRODUCT's ID

FACTORY(FID(PK), OID(FK)) -- OID references SUPPLIER' SID

To get ids of factories which might make the product "Acme Jetpack", what goes in the blank?

SELECT FID

FROM PRODUCT, SUPPLIER, SUPPLIES, FACTORY

WHERE PNAME = 'Acme Jetpack' AND ___________ <----- answer this part