Write a procedure that will accept the same employee identification number, extract and display the employee(s) job history information as depict below. Note: 03-APR-20 in the sample output represent today's date: Employment History: 1. 110-Accounting Public Accountant 21-SEP-89 27-OCT-93 2. 110-Accounting Accounting Manager 28-OCT-93 15-MAR-97 3. 90-Executive Administration Vice President 16-MAR-97 03-APR-20

Write a procedure that will accept the same employee identification number, extract and display the employee(s) job history information as depict below. Note: 03-APR-20 in the sample output represent today's date: Employment History: 1. 110-Accounting Public Accountant 21-SEP-89 27-OCT-93 2. 110-Accounting Accounting Manager 28-OCT-93 15-MAR-97 3. 90-Executive Administration Vice President 16-MAR-97 03-APR-20

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

What will be the result of the following Statement? SELECT MOD(LENGTH(Student_NAME), 2) FROM Students Where student_name like '%a’ and DOB between '01-Jan-1991' and '01-Jan-1997'; There are four coding errors in the following statement. Identify them. Select Concat(StudentID || StudentName) as "student details" , To_char(DOB,”mm”) Birth_Month From Student Where StudentName like 'S*' and Department IN ('D103' or 'D102');
Modify the accompanying credit risk data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise.
MySQL Workbench Will the following select statements work? If the queries don’t work, explain why and then correct them.a-) SELECT NAME, EMPLOYEE_ID, SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE EMPLOYEE_ID = EMPLOYEE_ID AND NAME LIKE '%MITH';b-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE NAME LIKE '%MITH';c-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE E.EMPLOYEE_ID = EP.EMPLOYEE_ID AND E.NAME LIKE '%MITH';d-) SELECT ENAME, COUNT(*)FROM EMPWHERE ENAME = '&NAME'ORDER BY ENAME;e-) SELECT DEPT_ID, COUNT(*)FROM EMPGROUP BY DEPT_IDHAVING ENAME='ALIYE';f-) SELECT F_NAME, L_NAMEWHERE F_NAME LIKE '%A'FROM EMP, DEPT;g-) SELECT NAME, SALARYFROM DEPT, EMPWHERE DEPT.ID = EMP.ID AND SUM(SALARY);
I need to know how to loop through a SQL query using PDO in PHP while only returning results under a specific condition. Below is an example of a code of my problem which checks to see if the generated number already exists in the database and only then commits the task. (The generated number in the example below already exists in the database but it is not returning anything.) <?php $mark = 100; $random = $mark.rand(100000, 999999); $result = $pdo->query('SELECT user_ID FROM user'); $row = $result->fetchAll(PDO::FETCH_ASSOC); foreach($row as $rows) { if($rows == 100000324) { echo $rows["user_ID"] . '<br>'; } } ?>
The code below creates a table for the outcomes when 4 dice are rolled, and stores them as a DataFrame. Extend the code to print out the number of ways to obtain 15 as the total when 4 dice are rolled simultaneously.
MySQL Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME
I get the error below when I try to create this procedure. It should be in MYSQL. Is my syntax for MYSQL wrong? CREATE PROCEDURE PRC_INV_AMOUNTS (W_IN IN NUMBER) W_CHK NUMBER = 0; W_SUBT NUMBER = 0; W_TAX NUMBER = 0; SELECT COUNT(*) INTO W_CHK FROM INVOICE WHERE INV_NUMBER = W_IN; IF W_CHK = 1 THEN SELECT SUM(LINE_TOTAL) INTO W_SUBT FROM LINE WHERE LINE.INV_NUMBER = W_IN; W_TAX := W_SUBT * 0.08; UPDATE INVOICE SET INV_SUBTOTAL = W_SUBT, INV_TAX = W_TAX, INV_TOTAL = W_SUBT + W_TAX WHERE INV_NUMBER = W_IN; END IF; END; ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN NUMBER) W_CHK NUMBER = "0", W_SUBT NUMBER = "0", W_TAX NUMBER = "0" SELECT C' at line 1 The original problem asks for MYSQL code to Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The…
The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) False
i have insert a csv into a sql developer databse . there are many nulls like this INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,716INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,717INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,718INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,719INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,720INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,721INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,722INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,723INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,724INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);--Row 111,725INSERT INTO NAMES (YEAR, NAME,…
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)
Please due in C A sample run is as follows: ---=== EMPLOYEE DATA ===--- 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 5 ERROR: Incorrect Option: Try Again 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 1 EMP ID EMP AGE EMP SALARY ====== ======= ========== 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 222 Enter Employee Age: 22 Enter Employee Salary: 22222.22 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 333 Enter Employee Age: 33 Enter Employee Salary: 33333.33 1. Display Employee Information 2. Add Employee 3.…
USING MYSQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. HERE is what i have so far, but getting these errors DELIMITER // CREATE PROCEDURE DISPLAY_OWNER (INOUT I_OWNER_NUM varchar(10), OUT I_FIRST_NAME varchar(10),OUT I_LAST_NAME varchar (10)) BEGIN SELECT OWNER_NUM,FIRST_NAME,LASTNAME INTO I_OWNER_NUM,I_FIRST_NAME,I_LAST_NAME FROM OWNER WHERE OWNER_NUM = I_OWNER_NUM; END// DELIMITER; also i need to display these outputs CALL DISPLAY_OWNER('AK102') Expected Results I_OWNER_NUM I_FIRST_NAME I_LAST_NAME AK102 Ceyda Aksoy