Tables: employees (id(pk), name, job_code(fk)) jobs (code(pk), title, salary) mysql> SELECT * FROM employees; . | id | name | 1 | Captain Hook | 2 | Tiger Lily | 3 | Pocahontas | 4 | Meeko 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? | job_code | foreign key references jobs (code) 21 21 1 | (a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code - code; (b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code; [Select] [Select]
Tables: employees (id(pk), name, job_code(fk)) jobs (code(pk), title, salary) mysql> SELECT * FROM employees; . | id | name | 1 | Captain Hook | 2 | Tiger Lily | 3 | Pocahontas | 4 | Meeko 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? | job_code | foreign key references jobs (code) 21 21 1 | (a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code - code; (b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code; [Select] [Select]
Chapter3: Table Creation And Management
Section: Chapter Questions
Problem 2HOA: Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The...
Related questions
Question
![Refer to the sample tables and data below.
Tables:
employees (id(pk), name, job_code(fk))
jobs (code (pk), title, salary)
mysql> SELECT * FROM employees;
| id | name
+--
|
1 | Captain Hook
2
Tiger Lily
3 | Pocahontas
4 | Meeko
4 rows in set (0.00 sec)
mysql> select * from jobs;
| code
title | salary |
+-
I
author | 100.50
200.00
|
editor
3 manager 150.00 |
|
1
2
I job_code
3 rows in set (0.00 sec)
2
1 |
foreign key references jobs (code)
How many rows will the following commands return?
(a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code
= code;
(b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code;
[Select]
[Select]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffd5c5bed-428f-4fc6-88a2-4182bb244de6%2Ff6ba6d58-b691-495b-b8ea-165643b2fa80%2F4n0cf5_processed.png&w=3840&q=75)
Transcribed Image Text:Refer to the sample tables and data below.
Tables:
employees (id(pk), name, job_code(fk))
jobs (code (pk), title, salary)
mysql> SELECT * FROM employees;
| id | name
+--
|
1 | Captain Hook
2
Tiger Lily
3 | Pocahontas
4 | Meeko
4 rows in set (0.00 sec)
mysql> select * from jobs;
| code
title | salary |
+-
I
author | 100.50
200.00
|
editor
3 manager 150.00 |
|
1
2
I job_code
3 rows in set (0.00 sec)
2
1 |
foreign key references jobs (code)
How many rows will the following commands return?
(a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code
= code;
(b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code;
[Select]
[Select]
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr