SQL JOIN Problems: Table: Students I student id I first nane last nane1 advisor.id l 1I Tanisha1 Blake 21ess 1 3 I Tracy Wu 41 AlvinI Grand s | Felix I Zinmermann l Goldsmith NULL Table: advisors I advisor td I first nane last name 1 I James FrancisI I Cheng 2 | Amy 3 I Lamar 4 I Anita Alexander 1. Write down the result for the following SQL script: (5 points) SELECT s.first name AS studentn FROM students AS s INNER 30IN advisors AS a ON S.advisor id a.advisor id ame, a first.name AS advisor_name 2. Write down the result for the following SQL script: (5 points) SELECT s.first_name AS student_name, a.first_name AS advisor_name FROM students ASS LEFT JOIN advisors AS a ON s.advisor_id = a.advisor_id