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 HREmployees ProductionCategories ProductionProducts Production,Suppliers SalesCustomers SalesOrderDetails El SalesOrders Sales,Shippers