Write a DDL statement for creating a VIEW (named STU_ADVISORS) for the following scenario: The student advisor only needs to see the stunum (=PERSON. idnum), first (=PERSON. fname), last (=PERSON. lname) and and the adv_name (CONCAT PERSON. fname, a space " ", and PERSON. lname). Include students whether they have an advisor or not.