Employees(employee id, first name, last name, salary, hire date, job title, manager id,department id)Departments(department id, department name, location_ id)Which of the following queries will display the name of all employees who does not work for'EXECUTIVE' departmenta.SELECT first name, last name FROM employees WHERE department id not in (SELECTdepartment id FROM departments WHERE upper(department name) = 'EXECUTIVE');b.SELECT first name, last name FROM employees WHERE department id != (SELECTdepartment id FROM departments WHERE upper(department name) = 'EXECUTIVE');c.SELECT first name, last name FROM employees WHERE department id = (SELECTdepartment id FROM departments WHERE upper(department name) = 'EXECUTIVE');%3Dd.SELECT first name, last name FROM employees WHERE department id In (SELECTdepartment id FROM departments WHERE upper(department name) = 'EXECUTIVE');

Correct answer is (a) SELECT first_name, last_name FROM employees WHERE department id NOT IN (Select…

Answered: at id, department name, location id)…

at id, department name, location id) ueries will display the name of all employee nt ast name FROM employees WHERE depar epartments WHERE upper(department nan

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Name the button/icon of MS Access. * O Preview O Datasheet View O Design View

A: Given: Given an icon and we need to write the name of the icon.

Q: The following code would include: CREATE OR REPLACE TRIGGER TRG_LINE_PROD AFTER INSERT ON LINE…

A: Dear Student, The answer to your question with required explanation is given below -

Q: Name the Hourly Rate and Hours Worked arrays. Calculate the total cost of labour using SumProduct.…

A: SUMPRODUCT - This function in excel is used to multiply numerical type arrays together and returns…

Q: _FNAME VARCHAR(15) NOT NULL, INITIAL CHAR(1), _AREACODE CHAR(3) DEFAULT '615' NOT N…

A: Given CREATE 'TABLE CUSTOMER CU S_CODE NUMBER PRIMARY KEY, CUS_LNAME VARCHAR( 1 5) NOT NULL,…

Q: 8. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.

A: Please check the solution below

Q: Write a SELECT statement that will return the distinct productid and productname from the products…

A: SQL query: SELECT DISTINCT products.productid, products.productname, orders.order_details from…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: To enter Vendors and Expenses transactions: From the Navigation Bar, select Customers From the…

A: BELOW ? STEP BY STEP COMPLETE SOLUTION REGARDING YOUR PROBLEM WITH EXPLANATIONS :

Q: 5. For each order, list the order number, quoted price and the item description, when the category…

A: 5. To get the required results, we need to use ORDERS, OPRDERLINE, ITEM tables Query: SELECT…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: 10. Produce a list of each customer number and the third and fourth digits of his or her zip code.…

A: The query for a list of each customer number and the third and fourth digits of his or her zipcode…

Q: 7. In the OrderItems table, display the maximum item_price with the alias shown. 11.99 Max Item…

A: Algorithm:Select the maximum value of the item_price column from the OrderItems table.Display the…

Q: Field Туре Null Key Default Extra ITEM_ID char(4) NO PRI NULL DESCRIPTION char(30) YES NULL ON HAND…

A: SQL is structured query language used to create and maintain data in a database. SQL has direct…

Q: Complete the Where clause in the following statement, which should select only records whose…

A: The where clause for LastName field beginning with upper case is written as follows. Where…

Q: Write a SELECT statement that uses the ranking functions to rank products by the total quantity…

A: This query uses a JOIN between the Products and Order_Items tables to get the total quantity of each…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Employees(employee id, first name, last name, salary, hire date, job title, manager id,
department id)
Departments(department id, department name, location_ id)
Which of the following queries will display the name of all employees who does not work for
'EXECUTIVE' department
a.SELECT first name, last name FROM employees WHERE department id not in (SELECT
department id FROM departments WHERE upper(department name) = 'EXECUTIVE');
b.SELECT first name, last name FROM employees WHERE department id != (SELECT
department id FROM departments WHERE upper(department name) = 'EXECUTIVE');
c.SELECT first name, last name FROM employees WHERE department id = (SELECT
department id FROM departments WHERE upper(department name) = 'EXECUTIVE');
%3D
d.SELECT first name, last name FROM employees WHERE department id In (SELECT
department id FROM departments WHERE upper(department name) = 'EXECUTIVE');

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

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.
Country ISOCode3 Name PopDensity FJI Fiji 130 CHE LTU Switzerland 560 Lithuania 120 Complete the UPDATE statement to change 'Fiji' to 'North Macedonia' in the Country table. In the WHERE clause, identify the row to be changed using the PopDensity column. UPDATE Country SET WHERE Note: Your answers for SET and WHERE should include the column names followed by an equals sign and the corresponding value.
wrire a select statement to select year and the total numbers of the movie that year by using count() function and Group by clause.
Column name Datatype Description trainer_id Should increment what is the datatype and size?
Without using the MAJOR_CUSTOMER VIEW, retrieve the customer ID, first name, and last name for every customer whose credit limit is $500 or less.
Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address is 2643 Lugsi Dr., The number of bedrooms is 3, The number of floors is 2, The monthly rent is $775, The owner number is MA111. Make sure to include the period (.) in the address.
Jump to level 1 Country ISOCode2 Name Code HU Hungary 348 DE BY Germany 276 Belarus 112 Complete the statement to delete the row containing 'Belarus'. In the WHERE clause, identify the row to be deleted using the ISOCode2 column. DELETE FROM Country WHERE
The command DESC DEPARTMENTS shows the following information: Name year! DEPARTMENT ID NOT NULL NUMBER (4) DEPARTMENT NAME NOT NULL VARCHAR2 (30) MANAGER ID NUMBER (6) LOCATION ID NUMBER (4) Null? Туре Can LOCATION_ID have the value 12345? Yes No