Write a query (do NOT give me the DATA, give me the query that produces the data

Question

Write a query (do NOT give me the DATA, give me the query that produces the data) that would do the following: A) Find the name and how many years employed for each employee with 5 or more years service in this Employees table: You can use the practice areas on this webpage to experiment with this table. httts://sqlbolt.com/lesson/select_queries_with_outer_joins The actual exercises on that page are different (and you do not need to be able to do them), but you can use the practice area to test your query.

Explanation / Answer

The following query works :

select name,Years_employed from Employees where Years_employed>=5;

this is achieved using relational operator on the column years_employed

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.