SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   MANAGER 
 INTERSECT  
 SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   CUSTOMER 
 ----------------------------------------------------------------
 SELECT   M.FIRSTNAME, 
          M.LASTNAME, 
          M.ADDRESSLINE1, 
          M.CITY, 
          M.STATEPROVINCECODE, 
          M.POSTALCODE 
 FROM     MANAGER M 
          INNER JOIN CUSTOMER C 
            ON M.FIRSTNAME = C.FIRSTNAME 
               AND M.LASTNAME = C.LASTNAME 
               AND M.ADDRESSLINE1 = C.ADDRESSLINE1 
               AND M.CITY = C.CITY 
               AND M.POSTALCODE = C.POSTALCODE 
 GROUP BY M.FIRSTNAME,M.LASTNAME,M.ADDRESSLINE1,M.CITY,
          M.STATEPROVINCECODE,M.POSTALCODE -
 
 ---------------------------------------------------------------- 
 SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   MANAGER  
 EXCEPT 
 SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
   POSTALCODE 
 FROM   CUSTOMER 
 ---------------------------------------------------------------
 SELECT   M.FIRSTNAME, 
          M.LASTNAME, 
          M.ADDRESSLINE1, 
          M.CITY, 
 M.STATEPROVINCECODE, 
          M.POSTALCODE 
 FROM     MANAGER M 
 WHERE    NOT EXISTS (SELECT *   FROM   CUSTOMER C 
    WHERE  M.FIRSTNAME = C.FIRSTNAME 
       AND M.LASTNAME = C.LASTNAME 
      AND M.ADDRESSLINE1 = C.ADDRESSLINE1
    AND M.CITY = C.CITY 
 AND M.POSTALCODE = C.POSTALCODE) 
 GROUP BY M.FIRSTNAME,M.LASTNAME,M.ADDRESSLINE1,M.CITY,
    M.STATEPROVINCECODE,M.POSTALCODE 
 ---------------------------------------------------------------- SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   MANAGER 
 INTERSECT  
 SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   CUSTOMER  
 EXCEPT 
 SELECT FIRSTNAME, 
        LASTNAME, 
        ADDRESSLINE1, 
        CITY, 
        STATEPROVINCECODE, 
        POSTALCODE 
 FROM   SALESREP