Question: Your task is to create a report (query output) that shows employee names, their hire date and the number of years employed (use DateDiff function.)

Your task is to create a report (query output) that shows employee names, their hire date and the number of years employed (use DateDiff function.) To accomplish this, create a query that includes the following:

a. Employee names concatenated (including TitleOfCourtesy, FirstName and LastName with the alias Employee Name

b. HireDate formatted mm/dd/yy (or any format you choose) with the alias Hired

c. Show number of years employed with alias Years Employed

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!

Mysql 1. Your task is to create a report (query output) that shows employee names, their hire date and the number of years employed (use DateDiff function.) To accomplish this, create a query that...

1. Create a SQL query that shows the first_name, last_name, hire_date, and the number of days that the employee has worked from the EMPLOYEES table. Use the concatenation operator to put the...

Create a SQL query that shows the first_name, last_name, hire_date, and the number of days that the employee has worked from the EMPLOYEES table. Use the concatenation operator to put the first_name...

1. Create a SQL query that shows the first_name, last_name, hire_date, and the number of days that the employee has worked from the EMPLOYEES table. Note: this is the EMPLOYEES table that came with...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

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

please give me all 25 question answer as soon as possible. You need to use your owned SQL knowledge to verify all multiple question answers and hand-on exercise questions. Enjoy leaning SQL in...

1. Evaluate this SQL statement: SELECT manufacturer_id, COUNT(*), order_date FROM inventory WHERE price > 5.00 GROUP BY order_date, manufactured_id HAVING COUNT(*) > 10 ORDER BY order_date DESC;...

Homework #4 ~ Single Table Queries 1) Create a query that will show the name of each customer and their phone number for all customers who live in Shelby township. Make sure the first and last name...

Set up (but do not solve) an ICE chart for this reaction, given the initial conditions. 3O2 (g) + 2O3 (g) 0.075 M

A company with a WACC of 10.0% is considering a project with the following cash flows: Initial investment = -$475; Years 1-3 = $200. O 2.38 years O 2.42 years O 2.61 years O 1.97 years O 2.26 years

9. The Wall Street Journal provides the net asset value, the year-to-date percent return, and the three-year percent return for 555 mutual funds (The Wall Street Journal, April 25, 2003). Assume that...

Question 2 2 ( 1 point ) Two VALS segments stand apart. One segment represents the group with the highes resources and innovation and the other segment represents the group with the lowest resources...

How does HRM become more complex as a companys workforce reaches 25 employees?

Assume that each job candidate accepts the companys job offer. Calculate the number of job offers necessary to maintain the required staffing level of 100 employees on an annual basis.

Explain how the seven employability skills matter regardless of your career aspirations.