Write the DML statement to query the database for all peoples' first name, last name, email address, advisor's first name, last name, and twitter address. Hint: This should print out for all people regardless of whether they actually have email addresses or advisors. Advisors should print regardless of whether they have a twitter handle.

Respuesta :

Answer and Explanation:

select fname, lname, D.smaddr , AdivsorList.fname, AdivsorList.lname, AdivsorList.smaddr,

from PERSON P

left outer join DIGITAL D

ON P.idnum = D.idnum

left outer join

(SELECT P1.fname, P1.lname , A.idnum, D1.smaddr

from

ADVISOR A

left outer join Person P1

ON A.idnum = D1.idnum

left outer join DIGITAL D1

ON P1.idnum = D1.idnum

) as AdivsorList

ON P.idnum = AdivsorList.idnum