How to write this code in T-SQL?

Tags:
T-SQL
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).
CustLastName         CustomerID DollarValueOfOrders

-------------------- ---------- ---------------------------------------

Sullivan             I-300022   2927.03

 

(1 row(s) affected)
How do I write this out?


Software/Hardware used:
Microsoft studio 2012
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Why? What problem are you having with it? What do you have so far in your attempts to solve it? It looks like a task that was assigned to you, so why would we do it for you?
    34,940 pointsBadges:
    report
  • ToddN2000
    Post the code you have written so far. We can show you where the problem is so you can fix it. If we do the work do we get the credit?
    132,520 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: