question 14please use the picture below to answer the following questionDisplay employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep". Invoice tableColumnDEFAULTPKNOT NULL UNIQUEFKVALIDATIONColumn NamesDataTypesVALUEInvoiceNum|IntegerInvoiceDateDateCustomerNumIntegerInvoice_DetailColumnDEFAULTtable ColumnPKNOT NULL UNIQUEFKVALIDATIONDataTypesVALUENamesInvoice_number |IntegerProd_IDQuantityIntegerIntegerValue mustpriceDecimal(3,0)be >0 EmployeeCustomerInvoicePK EmployeelDPK Customer_NumberCustomer NamePK Invoice_NumberInvoice_DateFK Customer_NumberEmp_FNameEmp_LNamesoc_InsFK Position_IDFK Supervisor_IDLocationFK Rep_IDInvoice_DetailPositionPK,HireDateInvoice_NumberFK1PK Position_IDPI,PositionProd_IDFK2QuantityTitlePricePKTitle_IDTitleAuthorAuthor_ProductProductPK Author_IDPK,PKProduct_IDAuthor_IDFK1Author_FNameFKTitle_IDEditionAuthor LNamePK,Prod_IDFK2FKEdition_IDPK Edition_IDPurchase_CostEditionRetail_Price

SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

please use the picture below to answer the following question Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".

please use the picture below to answer the following question Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter7: User Creation And Management

Section: Chapter Questions

Problem 17MC

See similar textbooks

Related questions

Q: (c++) question 1: create struct to store information for 10 students (student name, mark1, mark2,…

A: Algorithm: Start Define a structure with name Student and data members name, marks1, marks2,marks3…

Q: In which clause should you include the condition MAX(cost) > 39 to restrict groups displayed in…

A: The HAVING clause is used with the aggregated functions. examples of aggregated functions are sum,…

Q: Write a SELECT statement that returns the companyname, address, city and postalcode from the…

A: We need to display companyname, address, city and postalcode from the suppliers table Tables needed:…

Q: Q1. Please write SQL codes to query data from member tables based on below criteria Please write a…

A: In step 2, you will get error-free SQL query.

Q: if you want to get username from user table how to do this query O SELECT USERNAME FROM USER GET…

A: The USER_NAME() function returns the database user name based on the specified id. If id is not…

Q: Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from…

A: Sample Response: select Trading_Symbol ,Num_Shares from rows where Selling_Price > Purchase_Price…

Q: In which clause should you include the condition "pubid = 4" to restrict the rows processed by a…

A: By the given problem, it is required to use the condition "pubid = 4" to filter the entries of the…

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

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

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

Q: enter null value in a column where the Unique constraint is assigned to that column

A: enter null value in a column where the Unique constraint is assigned to that column True or False

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: As per guidelines we are supposed to answer only first 3-sub parts at time. please repost the…

Q: Question 8. All rows correspond to students whose rollnum's are between 20 and 30. (i) SELECT * FROM…

A: Given sentence in SQL database

Q: 1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and…

A: As per the database question we will give the query for all of them. 1. select last_name, salary…

Q: QUESTION 2 Exercise: Create a statement that will show the sum of all the payments received on or…

A: The sql query for the following is

Q: Create a query to display all names where the first name starts with letters in the J-R range. Use…

A: SQL Language to display all name where first name start with j - r range . Using between

Q: Write Queries for the following: a. List all student whose Surname begins with b or end with a or…

A: Question 3 is answered as per the guidelines, please repost other questions. The data inserted into…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: According to the question here we will choose in statement while writing the subquery. The subquery…

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Create a query that displays each instructor schedule. Display the instructor name, course title,…

A: Actually, the answer has given below:

Q: Part II: Complete the following exercise: Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: SELECT name FROM instructor WHERE salary = 90000; This query can be replaced by which of the…

A: In the given sql query, the "instructor" table is used. But in option b and option c, employee table…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: 9. SELECT rep.rep_ID,rep.last_name,rep.first_name FROM rep WHERE rep.rep_ID IN (SELECT rep_ID FROM…

Q: Create a stored procedure that will list all customers (name and number) represented by rep 15

A: create table cust_records(cust_num int primary key,cust_name varchar(30));insert into cust_records…

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: Create a student table. The student table needs to include the following columns: Student ID Student…

A: The solution for the above given question is given below:

Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…

A: For given InstantRide Finance team database, need to write query to create a SELECT statement which…

Q: List the owner number and last name for all owners located in the city of Seattle. Your query should…

A: Since no name is given so i am assuming the name of the table is OWNER

Q: Q#1 Print the name of players who played any tournament organized by “hafiz asif”. (Nested Queries)…

Q: When used in a parameter query, which of the following WHERE clauses will select the records for…

A: Parameter Query When a Query is used multiple times with different values each time, parameter query…

Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…

A: Since you have not specified the table name , let us assume that the data is present in TRAVELS…

Q: Not all Global Fast Foods staff members have a manager. Create a query that displays the employee…

A: To create a query that display the employee last name and 9999 in the manager ID column.

Q: SELECT DISTINCT empname FROM employee; In what order are the empnames displayed?

A: We are given a SQL query and we are going to find out the output of it. We are using DISTINCT…

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: As per the requirement submitted above , kindly find the below solution.

Q: . Please write SQL codes to query data from member tables based on below criteria Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: For questions 4 and 5, use the following order for the rows in your truth tables. P Q T T T F F T F…

A: P Q ¬Q P ↔ ¬Q P ↔ Q (P ↔ ¬Q) ∧ (P ↔ Q) T T F F T F T F T T F F F T F T F F F F T F T F

Q: Question 20 The query in the figure below: Field: LastName Table: MEMBERS Sort: Show: Criteria: Like…

A: Defined the query in the given figure

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: Solution: Write a SQL SELECT statement that selects only the Name and Cost fields from records…

Q: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

A: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

Q: Task 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for…

A: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each…

Q: Selecting Multiple Columns When buying food, it is important to make sure it is fresh and not…

A: Answer to the given question The query to select the ProductName, ProductionDate and ExpirationDate…

Q: 4. Run the following Query: SELECT * FROM Books WHERE name = 'Book10'; 5. Create the "Explain plan"…

A: 4. Given SQL query: SELECT * FROM Books WHERE name = 'Books10'; We have to run this query and give…

Q: Using the sp_InsertTeamDetails (check link above) procedure, create a query to insert the following…

A: The table is given below:-

Q: What’s the purpose of a column qualifier? When are you required to use one?

A: 1. Column qualifiers are used for distinct access of the data values in order to identify them…

Q: In what order are output results displayed if a SELECT statement contains a GROUP BY clause and no…

A: Order displayed by output results The Group by clause is a Structured Query Language (SQL) command…

Q: Please write the final answer in the following answer table. question 1 question 2 question 3…

A: The answer as given below:

Question

question 14

please use the picture below to answer the following question

Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".

Invoice table
Column
DEFAULT
PK
NOT NULL UNIQUE
FK
VALIDATION
Column Names
DataTypes
VALUE
InvoiceNum
|Integer
InvoiceDate
Date
CustomerNum
Integer
Invoice_Detail
Column
DEFAULT
table Column
PK
NOT NULL UNIQUE
FK
VALIDATION
DataTypes
VALUE
Names
Invoice_number |Integer
Prod_ID
Quantity
Integer
Integer
Value must
price
Decimal(3,0)
be >0

Employee
Customer
Invoice
PK EmployeelD
PK Customer_Number
Customer Name
PK Invoice_Number
Invoice_Date
FK Customer_Number
Emp_FName
Emp_LName
soc_Ins
FK Position_ID
FK Supervisor_ID
Location
FK Rep_ID
Invoice_Detail
Position
PK,
HireDate
Invoice_Number
FK1
PK Position_ID
PI,
Position
Prod_ID
FK2
Quantity
Title
Price
PK
Title_ID
Title
Author
Author_Product
Product
PK Author_ID
PK,
PK
Product_ID
Author_ID
FK1
Author_FName
FK
Title_ID
Edition
Author LName
PK,
Prod_ID
FK2
FK
Edition_ID
PK Edition_ID
Purchase_Cost
Edition
Retail_Price

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 with 2 images

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

CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
Please help me with the solution: MySQL */ CREATE TABLE AGENT ( AGENT_CODE int, AGENT_LNAME varchar(15), AGENT_FNAME varchar(15), AGENT_INITIAL varchar(1), AGENT_AREACODE varchar(3), AGENT_PHONE varchar(8), AGENT_ADDRESS varchar(30), AGENT_CITY varchar(15), AGENT_STATE varchar(2), AGENT_ZIP varchar(5), AGENT_DATE_HIRED datetime, AGENT_YTD_PAY numeric, AGENT_YTD_FIT numeric, AGENT_YTD_FICA numeric, AGENT_YTD_SLS numeric, AGENT_DEP int ) ENGINE = InnoDB; INSERT INTO AGENT VALUES('501','Alby','Alex','B','713', '228-1249','123 Pleasant View Dr.','Nashville','TN','37119', '2000-11-1','26566.24','6641.56','2125.3','132735.75','3'); INSERT INTO AGENT VALUES('502','Hahn','Leah','F','615', '882-1244','334 East Main Street','Louisville','KY','25246', '1986-5-23','32213.76','8053.44','2577.1','138967.35','0'); INSERT INTO AGENT VALUES('503',' Okon','John','T','615', '123-5589','452 Technology Circle','Oak Ridge','TN','36155', '2005-6-15','23198.29','5799.57','1855.86','127093.45','2'); CREATE…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70 $400.00 29 GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 $215.00 $225.00 22…
8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
CONSIDER THE INVOICE TABLE BELOW: invoice id NUMBER (12), invoice date DATE,Invoice total NUMBER (9, 2), payzent_total NUBER (9, 2), credit total NUMBER (9, 2),invoice due date DATE, payrent date DATE,CIL REC user VARCHAR2 (12),CTL SEC level NUMBER (1)Consider the INVOICE table structure below: A trigger is created on the INVOICE table: CREATE OR REPLACE TRIGGER rg_On_Quiz before insert or update on Invoice FOR EACH ROW DECLARE V_level Number; V_name VARCHAR (20); Begin SELECT USERNAME, SECURITY_LEVEL INTO V_name, V_level FROM AUTHORIZED_USERS WHERE USERNAME = USER; :NEW.CTL_REC_user := V_name; :NEW.CTL_REC_user := V_level; EXCEPTION WHEN NO_DATA_FOUND THEN RAISE_APPLICATION_ERROR (-2003, 'UNAUTHORIZED USER'); END; In Oracle/PLSQL, the USER function returns the user_id from the current Oracle session. a.) Explain what this triger does…
The InstantRide Marketing team wants to organize an InstantRide party. The team requires first name and last name of all the users and drivers in order to create a gate-pass for their entry. You need to join USERS and DRIVERS tables using UNION and return FIRST_NAME and LAST_NAME columns.