Given the following SQL query:

SELECT SUPNAME, SUPADDRESS, SUPCITY

FROM SUPPLIER R

WHERE NOT EXISTS

$($SELECT $*$

FROM PRODUCT P

WHERE EXISTS

$($SELECT $*$

FROM SUPPLIES $S$

WHERE R$.$SUPNR $=$ S$.$SUPNR

AND P$.$PRODNR $=$ S$.$PRODNR$))$;

This query selects:

The supplier name, supplier address and supplier city of all suppliers who cannot supply all products.

The supplier name, supplier address and supplier city of all suppliers who cannot supply any products.

The supplier name, supplier address and supplier city of all suppliers who can supply all products.

The supplier name, supplier address and supplier city of all suppliers who can at least supply $1$ product.