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.

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

a local network will allow everyone in the office to share the printer.

research the organization

compare your skills and qualifications

prepare responses

plan what to wear

plan what to bring

pay attention to non- verbal communication

follow up