3. Modify p2ql.sql to display the name and salary for all employees whose salary is not in the range of $1500 and $2850. Resave your SQL statement to a file named p2q3.sql. Rerun your query. ENAME SAL SMITH 800 WARD 1250 JONES 2975 MARTIN 1250 SCOTT 3000 KING 5000 ADAMS 1100 JAMES 950 FORD 3000 MILLER 1300 10 rows selected. 4. Display the employee name, job and start date of employees hired between February 20. 1981, and May 1. 1981. Order the query in ascending order by start date. ENAME JOB HIREDATE ALLEN SALESMAN 20/02/1981 WARD SALESMAN 22/02/1981 JONES MANAGER 02/04/1981 BLAKE MANAGER 01/05/1981

3. Modify p2ql.sql to display the name and salary for all employees whose salary is not in the range of $1500 and $2850. Resave your SQL statement to a file named p2q3.sql. Rerun your query. ENAME SAL SMITH 800 WARD 1250 JONES 2975 MARTIN 1250 SCOTT 3000 KING 5000 ADAMS 1100 JAMES 950 FORD 3000 MILLER 1300 10 rows selected. 4. Display the employee name, job and start date of employees hired between February 20. 1981, and May 1. 1981. Order the query in ascending order by start date. ENAME JOB HIREDATE ALLEN SALESMAN 20/02/1981 WARD SALESMAN 22/02/1981 JONES MANAGER 02/04/1981 BLAKE MANAGER 01/05/1981

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

Similar questions

How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice_id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row C. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item Full_price sale_price Apple 25 NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows
Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. When you finish Problems 7–15, the EMP_2 table will contain the data shown in Figure P8.15.
8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement and also provide the output of each query to answer the following questions. (Screenshot the interface in MySQL that show SQL statement and output for each question). Table 1: PROPERTY pid 1 2 3 1200000 4 5000000 price 100000 3400000 owner Alia Bob Bob Marsha Table 2: MAINTENANCE mid company Name M1 Super Plumbing M2 Super Plumbing M3 South Carpeting srqFeet 560 2000 1200 800 empName George Dave Kim managed By Property Pete Park Property Property Pete Fancy Property location Lake View Serene Serene Lake View date 2020-12-12 type Sink 2020-11-11 Toilet 1 2021-01-01 Painting 4 Pid 1 d)' List property location, owner name and maintenance date for property managed by Property Pete. Sort the answer in descending order by property location.
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
SQL QUERIES Employees(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID,DEPARTMENT_NAME)Department(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)Location(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) Write a query in SQL to display the DEPARTMENT_NAME of all those Departments whoseDEPARTMENT_ID is greater than the DEPARTMENT_ID of Physics department. Write a Query in SQL to show the FIRST_NAME of all those employees whose salary is lessthan the salary of all those employees whose MANAGER_ID is 101 or 102.
Write the T-SQL scripts for the following tasks: Write a query to list the first name and last name of the employee with the highest salary in the financedepartment
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
Write the SQL syntax to create a table in the database called Employee with the employee first and last name, employee hire date, employee number, employee initial, and employee years.
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345