7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

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

write SQL statement to search for employees whose manager is specified by the txtEname box
How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films
I need C please
4. In the OrderItems table, display a count of the number of products, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BR03 4 rows returned in 0.00 seconds PROD_ID Download 3 3 3 4 NUM_PROD_ID
Q5) What is the normalization of the following table, where the primary keys are underlined: Note: all the data in cells of the table are already atomic. OrderID Order Date 1006 1006 10/24/2010 1006 1007 10/24/2010 1007 10/24/2010 10/25/2010 10/25/2010 Customer Customer Customer ProductID Product ID Name Address Description 2 2 2 6 6 Value Furniture Value Furniture Value Furniture Plano, TX Plano, TX Plano, TX Furniture Boulder, Gallery CO Furniture Boulder, Gallery CO 7 5 4 11 Dining Table Writer's Desk Product Product Finish Standard Price 4-Dr Dresser Natural 800.00 Ash Cherry 325.00 Entertainment Natural 650.00 Center Maple 500.00 4 Entertainment Natural 650.00 Center Maple Ordered Quantity 2 2 1 4 3
5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit Less than 80000. (Use inner join)
q15- Please choose all that apply
e) Display the sum of salaries of employees from each department ordered in ascending order.
Question 3 refers to two data tables giving the details of a company's employees and company's job titles, called EMP and JOB respectively, which have the following format: Table EMP Column name Column type Integer Up to 10 characters Example entry Description Employee ID number Employee surname EMPNO 7369 ΕΝΑΜΕ SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager Date employment started Monthly salary HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 characters Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN b) Using EMP and JOB tables, give an example of the JOIN SQL statement which uses "WHERE", "GROUP BY", “HAVING" and “ORDER BY" clauses. Explain the result table of the SQL statement. (Maximum 300 words).
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.