1. Write a query to display the employee name and hiredate for all employees in the samedepartment as Blake. Exclude Blake.ENAMEHIREDATEALLEN20-FEB-81WARD22-FEB-81MARTIN28-SEP-81TURNER08-SEP-81JAMES03-DEC-812. Create a query to display the employee number and name for all employees who earnmore than the average salary. Sort the results in descending order of salary.7839 KING7902 FORD7788 SCOTT7566 JONES7698 BLAKE7782 CLARK6 rows selected.

According to the Question below the Query:

1. Write a query to display the employee name and hiredate for all employees in the same department as Blake. Exclude Blake. ENAME HIREDATE ALLEN WARD 20-FEB-81 22-FEB-81 MARTIN 28-SEP-81 TURNER DAMES 08-SEP-81 03-DEC-81 2. Create a query to display the employee number and name for all employees who earn more than the average salary. Sort the results in descending order of salary. 7839 KING 7902 FORD 7788 SCOTT 7566 JONES 7698 BLAKE 7782 CLARK

1. Write a query to display the employee name and hiredate for all employees in the same department as Blake. Exclude Blake. ENAME HIREDATE ALLEN WARD 20-FEB-81 22-FEB-81 MARTIN 28-SEP-81 TURNER DAMES 08-SEP-81 03-DEC-81 2. Create a query to display the employee number and name for all employees who earn more than the average salary. Sort the results in descending order of salary. 7839 KING 7902 FORD 7788 SCOTT 7566 JONES 7698 BLAKE 7782 CLARK

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

Similar questions

Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
Not all Global Fast Foods staff members have a manager. Create a query that displays the employee last name and 9999 in the manager ID column for these employees.
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
8) Create a query for displaying list of employees who joined in the second half of year ‘07’;
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee num-ber, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2015, and December 5, 2015. If there is a tie for most units sold, sort the output by employee last name
From vendors table, write a query to retrieve records as follows: On the first column, add vendorcontact first name, a space, and vendor contact last name. Name the first column “Vendor ContactFull Name”. On the second column, retrieve the total number of characters of the “Vendor ContactFull Name” column. Do NOT count the space in between first name and last name. Name thesecond column “Full Name Length”.The two columns should look like this:Vendor Contact Full Name Full Name LengthJinsoo Yeo 9Hint1: CONCAT and CHAR_LENGTH functions might be useful!Hint2: the number of characters for Francesco Alberto is 16.
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
b. Write a query to get the average salary and the total number of employees who work in the History department (in that order). c. Write a query to get the number of employees working in the History department with a job title of Head of Department.