Question: QUERY 1: Write and run an SQL statement to display first name, last name, and age of employees whose manager results from oldest employees to

QUERY 1: Write and run an SQL statement to display first name, last name, and age of employees whose manager results from oldest employees to youngest employees. (NOTE: In Oracle SQL gives today's date.) is 105, Display the , you can use the keyword SYSDATE which Partial output appears below for your reference. Your screenshot should show complete query, its complete output, and our account email address. Also, please be sure that column captions are the same as below. Round any numbers to two ecimal places. First Name Last Name Employee Age Rupert Jeanine Smith Melanie Smythe Washington 52.79 50.68 48.09

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

LAB OVERVIEW Lab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. This lab will also introduce the fundamentals of...

* Oracle Database * Question 3: Write a SQL query that display first name, last name and the job title of employees that their job ids are SA_MAN. (15 point) Answer 3: Question 4: Write a SQL query...

please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Need help writing queries for: Part 1. Projection and Selection 1.1 Please get all data in the Employees table. 1.2 I want to get the contact names and phone numbers of my suppliers in Australia. 1.3...

Need help with part 2 Part 2. Sorting; logical operators (and, or) 2.1 I want to get a list of customer in these cities: Berlin, Madrid, London, Bern. Order the results by city. 2.2 Get all orders...

please any help for this SQL query *) Display employee names and dependent information. Also include those employees that dont have any dependent. *) Find out the employee names and number of years...

Write an SQL statement to display full name of employees supervised by the manager whose ID is 105. Note that full name includes first name, a space, and last name. Also note the caption/heading of...

Need help with part 3 Part 3. Simple table join 3.1 Display first and last names of ALL employees along with names of their managers. 3.2 Get the employee who processed the order 9905 (order id);...

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

Assume that the business in Exercise 6-7 maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory...

The primitive flow table for an asynchronous sequential circuit is shown in Table 4. (a) Construct a Merger Table. (b) List all possible minimal set of closed compatibles to cover the machine. (c)...

1 . Rubber used to form the cores . 2 . Factory maintenance . 3 . Wages paid to assembly workers . 4 . Glue used in binding rubber cores to felt covers . 5 . Depreciation on Factory equipment . 6 ....

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+10. Suppose the United States adopted central planning for its economy, and you became the chief planner. Among the millions of decisions that you need to make for next year are how many

=+ 9. Your roommate is a better cook than you are, but you can clean more quickly than your roommate can. If your roommate did all the cooking

=+ b. How does the reduction in benefits associated with higher earnings affect peoples incentive to work past age 65?