The california_emp table includes one row with name=’Sandy Tilbrook’, with office_id=’CA086′. There is no row in california_offices with office_id=’CA086′. However, there is a office_id=’CA070′ in california_offices with city=’Redding’, but no rows in california_emp have office_id=’CA070′. (There are no other rows with city=’Redding’.) Choose the response that best describes how these rows will be included in the result set of this query:

Question 8
The california_emp table includes one row with name=’Sandy Tilbrook’, with office_id=’CA086′. There is no row in california_offices with office_id=’CA086′. However, there is a office_id=’CA070′ in california_offices with city=’Redding’, but no rows in california_emp have office_id=’CA070′. (There are no other rows with city=’Redding’.) Choose the response that best describes how these rows will be included in the result set of this query:

SELECT name, city, salary

FROM california_emp e

INNER JOIN california_offices o ON e.office_id = o.office_id;

1 point

• A row with name=’Sandy Tilbrook’ will be included, and a row with city=’Redding’ will be included
• A row with name=’Sandy Tilbrook’ with be included, but no row with city=’Redding’ will be included
• No row with name=’Sandy Tilbrook’ will be included, and no row with city=’Redding’ will be included
• A row with city=’Redding’ will be included, but no row with name=’Sandy Tilbrook’ will be included