PERSON

ADVISOR

DIGITAL

 #15 Write the DML statement to query the database for all peoples' fname, lname, rname, 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.

+ - - - - - - - + - - - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - + | idnum | lname fname Trname | private linkblue + - - - - - - -+ - - - -- - - - - + - - - - - - - - - - - + - - - - - - - - -- - - + | 22222 Clemens | Timothy | 40256 South | William | 55555 | North Dan | 56732 | Cox Courtney | 68123 Smith | Terry | clemens. timothy@uky.edu south.william@uky.edu north.dan@uky.edu NULL | smith.terry@uky.edu | tgc1258 1 | weso123 o ddno453 1 | cc0546 1 | tlsm321 | | | + - - - - - - - + - - - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - + - - - - - - - - - - + .. . . . . . . - + - - | student | advisor | student_name_ advisor_name | sdate edate | - - - + - - - - - - - - - - - - + - 40256 | 68123| 40256 | William South 68123 | Terry Smith Abby Tanner NULL Nicole Taylor | NULL NULL | NULL I .. . + .. . - - -- - - -- - - -+ - - -- - - -+ . . + - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - - - - + | idnum | smtype smaddr + - - - - - - - + - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - + | 22222 | facebook | facebook.com/clemons. timothyl 40256 | facebook | facebook.com/south.william | 68123 | facebook | facebook.com/smith.terry twitter twitter.com/clemons. timothy 40256 | twitter | twitter.com/South.william | 68123 | twitter | twitter.com/smith.terry - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +