Refer to the sample tables and data below. Tables:employees…

Refer to the sample tables and data below. Tables:employees (id(pk), name, job_code(fk)) — foreign key references jobs(code)jobs (code(pk), title, salary)mysql> SELECT * FROM employees;+—-+——————+———-+| id | name | job_code |+—-+——————+———-+| 1 | Captain Hook | 1 || 2 | Tiger Lily | 2 || 3 | Pocahontas | 2 |+—-+——————+———-+4 rows in set (0.00 sec)mysql> select * from jobs;+——+———+——–+| code | title | salary |+——+———+——–+| 1 | author | 100.50 || 2 | editor | 200.00 || 3 | manager | 150.00 |+——+———+——–+3 rows in set (0.00 sec) How many rows will the following commands return?  (a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code = code; [a](b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code; [b]

Refer to the sample tables and data below. Tables:people (id…

Refer to the sample tables and data below. Tables:people (id(pk), firstname, lastname, zip(fk)) — foreign key references zip_code(zip)zip_code (zip(pk), city, state)mysql> select * from people;+—-+———–+———-+——-+| id | firstname | lastname | zip |+—-+———–+———-+——-+| 1 | Marty | McFly | 45001 || 2 | Jennifer | Parker | 33647 || 3 | Lorraine | McFly | 33647 || 4 | Biff | Tannen | 33647 || 5 | George | McFly | 07005 |+—-+———–+———-+——-+5 rows in set (0.01 sec)mysql> select * from zip_code;+——-+————+——-+| zip | city | state |+——-+————+——-+| 45001 | New York | NY || 07005 | New Jersey | NJ || 33647 | Tampa | FL || 33620 | Tampa | FL || 33765 | Clearwater | FL |+——-+————+——-+5 rows in set (0.01 sec) Fill in the blank with the word(s) that complete the command below, so that it returns the following result set:  +——-+——————+| zip | COUNT(firstname) |+——-+——————+| 45001 | 1 || 07005 | 1 || 33647 | 3 || 33620 | 0 || 33765 | 0 |+——-+——————+SELECT zip_code.zip, COUNT(firstname) FROM zip_code __________ people ON people.zip = zip_code.zip GROUP BY zip_code.zip;