1. Write down the result for the following SQL script: (5 points) SELECT s.first_name AS student_name,...

 

Transcribed Image Text:

1. 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 AS s INNER JOIN advisors AS a ON s.advisor_id = a.advisor_id; 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 AS s LEFT JOIN advisors AS a ON s.advisor_id = a.advisor_id; SQL JOIN Problems: Table: Students | student_id | first_name | last_name | advisor_id | 1 1 | Tanisha 2 Jess 3 | Tracy 4 | Alvin 5 | Felix Table: advisors | Blake | Goldsmith | | Wu 1 | Grand |Zimmermann | | advisor_id | first_name | last_name | | Francis | I | Cheng I | Alexander | | Woods I 1 | James 2 Amy 3 | Lamar 4 | Anita 21 NULL | 31 1 | 21 1. 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 AS s INNER JOIN advisors AS a ON s.advisor_id = a.advisor_id; 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 AS s LEFT JOIN advisors AS a ON s.advisor_id = a.advisor_id; SQL JOIN Problems: Table: Students | student_id | first_name | last_name | advisor_id | 1 1 | Tanisha 2 Jess 3 | Tracy 4 | Alvin 5 | Felix Table: advisors | Blake | Goldsmith | | Wu 1 | Grand |Zimmermann | | advisor_id | first_name | last_name | | Francis | I | Cheng I | Alexander | | Woods I 1 | James 2 Amy 3 | Lamar 4 | Anita 21 NULL | 31 1 | 21