With a single query, create a new table named NEWEMPLOYEE containing the Number,

Question

With a single query, create a new table named NEWEMPLOYEE containing the Number, Name, and Salary of every employee in the EMPLOYEE table whose name ends with "e" (Assume there can be many different names that can end with "e"). Return the aggregate delivered quantity for all departments with total number of received deliveries (not delivered quantity!) greater than 7. Show the department name and the aggregate delivered quantity in your output. Use appropriate names for the columns. Order the results in descending by the number of received deliveries.

Explanation / Answer

Answer for Problem 3 :

SELECT * from EMPLOYEE where name = *e

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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