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.

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’)

the aksumite empire was an ancient kingdom located in what is now northern ethiopia from the period of 100 ad to 940 ad. its capital was the city of aksum. the kingdom established itself as one of the 4 great powers at its time, along with persia, rome, and china.

the kingdom was rich in goods like gold, iron, and salt. it established strong commercial ties with the regions governed by rome, egypt, and persia (arabia). aksum was a key location in this commercial network. trade was also facilitated with the introduction of the aksumite currency.

answer; with few regulations protected the prices of crops which made farmers leave their farms and migrate to the big cities to work in factories;