contestada

Write a SELECT statement that returns the LastName and JobTitle of each employee with a jobtitle other than ‘Engineer’ that has a SalaryWage greater than 65% of what the lowest paid employee with a jobTitle of engineer is paid.

Respuesta :

temmydbrain

Answer:

Check the explanation

Explanation:

the statement for returning the LastName and JobTitle of each employee with a jobtitle other than engineer is

SELECT Lastname, JobTitle

#then

From Employee

#the third line of command

WHERE JobTitle NOT LIKE ‘Engineer’ AND

#the fourth line of command

Salarywage >65%

#the fifth line of command

(SELECT MIN(SalaryWage)

#the sixth line of command

FROM Emloyee

#the seventh line of command

WHERE Jobtitle = ‘Engineer’)