This question has four parts: I have included the tables as a reference. a) Writ

Question

This question has four parts: I have included the tables as a reference.

a) Write the query that returns the following result set. This is from the HR.Employees table. The results must be explicitly sorted by the last name and the first initial. Only include employees whose first names start with the letters between R and Z inclusive.

b) Write a query without a FROM clause and using SQL Server date functions that return the following results (NOTE: Your query should return the current date, not the date that is displayed here, no literals allowed).

c) Write a query that provides the following result from the Sales.OrderDetails table using the appropriate functions and calculations.

d) Write a query that produces the following results. The query uses the Sales.OrderDetails table. The results are sorted by the line item total values from largest to smallest. The results should only contain line items where the net value is greater than $3,000.00. Further more, the line items must have a quantity of at least 100 items.

InsideTSQL2008 " Database Diagrams Tables System Tables FileTables External Tables HR·Employees Production·Categories Production·Products Production,Suppliers Sales·Customers Sales·OrderDetails El Sales·Orders Sales,Shippers

Explanation / Answer

d)
SELECT Order ID, Quantity, Line item Total  
FROM sales.orderDetails
WHERE Quantity > 99 AND Line item Total >3000.00
ORDER BY Line item total DESC;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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