EXERCISE-5.2

SELECT (E.EMAIL_ADDRESS), DISTINCT (DATE(EM.MESSAGE_DATE))
 FROM (
      (
        SELECT EMAIL
        FROM EMAIL.TOdistinct (
      ) UNION ALL(
        SELECT EMAIL
        FROM EMAIL.CC
      )
  ) AS A
INNER JOIN EMAIL.PERSON AS E
ON A.EMAIL = E.EMAIL_ADDRESS
INNER JOIN EMAIL.EMAILS AS EM
ON DATE(EM.MESSAGE_DATE) BETWEEN '2001.09.01' AND '2001.10.31'
WHERE E.FIRSTNAME = 'Larry' AND E.LASTNAME = 'May'
ORDER BY DATE(EM.MESSAGE_DATE) ASC