How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ATLProg Your Own Question

ATLProg
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 9151
Experience:  Expert in Java C++ C C# VB Javascript Design SQL HTML
44910485
Type Your Homework Question Here...
ATLProg is online now
A new question is answered every 9 seconds

Write a select statement that returns four columns: VendorName From

This answer was rated:

Write a select statement that returns four columns:

VendorName From the Vendors table
InvoiceNumber From the Invoices table
InvoiceDate From the Invoices table
Balance InvoiceTotal minus the sum of the PaymentTotal and CreditTotal

The result set should have only one row for each invoice with a non-zero balance.
Sort the result set by VendorName in ascending order.

Hi i can help, do you have the ERD or list of columns for each tables?

Can you please go to www.wikisend.com and upload your file ? Once you do that you will get a page that has the "File ID" and "Download Link". Copy the "Download Link" or "File ID" and please paste it in your reply here.

 

Customer: replied 4 years ago.

http://wikisend.com/download/362632/Tables.zip


 


I hope thats wht your requesting. I took some pictures of the tables.

Is this for some course you are taking..if so please upload the complete question text so that i have complete picture
Please try this

http://wikisend.com/download/248826/Question.docx

Please remember to rate my answer, I hope you found it to be Excellent ! If you didn't find it to be "Excellent" or are not 100% satisfied, please reply to me so that i can help you better.

For future reference - Please start your question text with "For ATLProg Only" to request me again. It will ensure that question comes to me.
Customer: replied 4 years ago.


OK thank you. That looks like it did it. It looks like when doing a "WHERE" on a alias "Balance" in the "WHERE" statement you have to enter the formula again. Correct?

THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
ATLProg and 3 other Homework Specialists are ready to help you