You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries will be correct? EMPLOYEES Null? Name EMP ID Type NOT NULL NUMBER(4) VARCHAR2(10) FIRST NAME VARCHAR2(10) VARCHAR2(9) VARCHAR2(4) LAST NAME JOB MGR HIRE DATE DATE NOT NULL NUMBER NUMBER(7,2) NUMBER(2) SALARY COMM PCT DEPT ID DEPARTMENTS Null? Type NUMBER VARCHAR2(20) VARCHAR2(20) Name DEPT ID DEPT NAME DEPT LOC O SELECT first_name, last_name FROM employees WHERE last_name = "Butcher' And first_name = 'Jessica' O SELECT first_name, last_name FROM employees WHERE department =100; O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher'); O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher' AND department = 100 AND employee_id = 40)

You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries will be correct? EMPLOYEES Null? Name EMP ID Type NOT NULL NUMBER(4) VARCHAR2(10) FIRST NAME VARCHAR2(10) VARCHAR2(9) VARCHAR2(4) LAST NAME JOB MGR HIRE DATE DATE NOT NULL NUMBER NUMBER(7,2) NUMBER(2) SALARY COMM PCT DEPT ID DEPARTMENTS Null? Type NUMBER VARCHAR2(20) VARCHAR2(20) Name DEPT ID DEPT NAME DEPT LOC O SELECT first_name, last_name FROM employees WHERE last_name = "Butcher' And first_name = 'Jessica' O SELECT first_name, last_name FROM employees WHERE department =100; O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher'); O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher' AND department = 100 AND employee_id = 40)

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: Question 6 (Must include subquery): Write, a query that returns every customer that has a loan at…

A: The query is given below with output screenshot Demo data has been used in tables

Q: Show the last name, the trip id, and arrival town of those pilots who have flown with more than 450…

A: Consider pilots table and it contains the attributes last name, trip id, arrival town, airport name.…

Q: Write a query to list clients ID, book number and days kept for each check out. Note: days kept is…

A: Below are the two commands that you can try: 1. Select PATRON.PAT_ID, BOOK.BOOK_NUM,…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure…

A: Call ADD_EMPLOYEE for the name Jane Harris in department 15. leaving other parameters with their…

Q: Commands In the sec0411_employees table, change the credit limit to $27.00 for

A: Update query is to change the values in a table as per the asked condition but the sql syntax is…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM…

A: The query selects the result of the expression 2*(Balance - Payment) for each row in the "Customer"…

Q: please assist with the following questions. need to write a syntax in SQL server. Create an UPDATE…

A: It is defined as SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to…

Question

You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following
queries will be correct?
EMPLOYEES
Туре
NOT NULL NUMBER(4)
VARCHAR2(10)
Name
Null?
EMP ID
FIRST NAME
VARCHAR2(10)
VARCHAR2(9)
VARCHAR2(4)
LAST NAME
JOB
MGR
HIRE DATE
DATE
SALARY
NOT NULL NUMBER
COMM PCT
NUMBER(7,2)
DEPT ID
NUMBER(2)
DEPARTMENTS
Туре
NUMBER
VARCHAR2(20)
VARCHAR2(20)
Name
Null?
DEPT ID
DEPT NAME
DEPT LOC
O SELECT first_name, last_name FROM employees WHERE last_name = 'Butcher' And first_name = 'Jessica';
O SELECT first_name, last_name FROM employees WHERE department =100;
O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher');
O SELECT first_name, last_name FROM employees WHERE department
(SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher' AND department = 100 AND employee_id = 40);

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Basic Information:

VIEW

Solution:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);
Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.
Write a Query using JOINS to display the Customer Name, Email, Delivery Address and Final Price of all orders whose Final Price is atleast 200 dollars.
Write a SQL query to find the customer# of those customers that purchased at least once in July 2020 but NOT in August 2020. In addition to the customer#, show the ISBN and title of the book(s) they purchased in July 2020. You may use only one query. No creating any temporary tables or subqueries. You may use only joins. SUBMIT a second solution in addition to your Level 1.