How do I code this T-SQL:
Write a summary query that returns three columns named CustLastName, CustomerID, and DollarValueOfOrders. The dollar value of the orders is to be the sum of the dollar value of the orders associated with the customer with the lastname of ‘Spaller’ and firstname of ‘Kimber’.
When you execute your code the results should come back looking similar to the following (sample shown below is associated with a different customer and is shown only to convey the nature of the results not the specific results).
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!