Please write the two queries for part a) and b). Here's the table structure.

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

Part b) 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