A query based on the Employee table to show all employees, who are 50 years old

Question

A query based on the Employee table to show all employees, who are 50 years old or above and have worked for the company for more than 15 years. Create three (3) calculated fields: Employee Age, Tenure, and Employee Name (combining first name and last name). Show only Employee Name, Employee Age, Tenure, and Job Title in the outcome.

I have all the fields in my db i just want to know the code. You should be able to write the sql based on the fields without being shown the database

Explanation / Answer

select Employee_name,Employee_age,Tenure,Job_Title from Employee where Employee_age>=50 and Tenure>15

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---