SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 5 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Jan 2018 My Price 7.00

Human Resources has requested a listing of employees

Please help quickly I need to create the following query in sql to create a report. I cannot figure out how to join tow select statments to get one out put with all the colums I need.

 

This is the request -Human Resources has requested a listing of employees. They want the listing to show the first initial of the employee's last name. In addition, they want the report in the following sort order: exempt/non-exempt status, the first letter of their last name, last name, first name and salary. For example: Exempt, S, Smith, Bob, $50,000

 

here is what I wrote- SELECT * FROM ['Employee Data$']
Join ['Job Title Table Week 1$'] on ['Job Title Table Week 1$'].[Job ID] = ['Employee Data$'].[Job ID]
ORDER BY Status, [Last Name], [First Name], Salary 
join Select [Last Name], SUBSTRING ([Last Name], 1, 1) AS Initial from ['Employee Data$']

 

Answers

SophiaPretty
(5)
Status NEW Posted 12 Jan 2018 01:01 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)