Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | May 2017 |
Last Sign in: | 305 Weeks Ago, 6 Days Ago |
Questions Answered: | 66690 |
Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
For submission, include both the SQL statement and the output rows in a Word document (include the problem number with each statement)
List the invoices with a balance due over $1,000.
The balance due is the amount A????1 (payments + credits).
Display the vendor ID, invoice ID, invoice date, and balance due.
Order the listing by the balance due, descending. Also, format the balance due.
2. Â Â Â Â Â Â Â List the mid-western vendors (Illinois, Indiana, Iowa, Michigan, Minnesota, Wisconsin).
Display the vendor ID, name, contact name (first & last), city, and state.
Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine).
Order the listing by the city within state.
Â
3. Â Â Â Â Â Â Â List the total for each line item description, giving the description and the total amount when the total > $5,000.
Use formatting and concatenation to reduce the space required for the description and to format the total as currency.
Order the output by the total, descending.
Â
4. Â Â Â Â Â Â Â List the vendors supplying a line item containing 'CICS', 'COBOL' , 'MVS', or 'VSAM'.
Include the vendor ID, name, invoice number, line item description and amount.
Use formatting to reduce the space required and format the amount as currency.
Order the listing by ID.
Â
5. Â Â Â Â Â Â Â List the invoices with a balance due that are at least 7 months past the due date.
Display the vendor ID & name, invoice number, date, due date and balance due.
Calculating the past due period should be based on the current run date, not a hard-coded date.
Order the listing by the due date.
Â
6. Â Â Â Â Â Â Â List the total balance due to each vendor, when the total balance due is over $100.
Just list the vendor name and the total.
Order the listing by the vendor name.
Â
7. Â Â Â Â Â Â Â List the total balance due to each vendor, when the total balance due is over $100.
List the vendor ID, name, phone and the total.
Order the listing by the total balance due, descending.
Â
8. Â Â Â Â Â Â Â List the vendor name and city/state where there is only one vendor in that city and state.
Â
9. Â Â Â Â Â Â Â List the top 5 invoices based on the highest balance due.
Give the vendor name, invoice date and balance due.
Â
10. Â Â Â Â Â List the top 10 percent of the invoices based on the highest balance due.
Give the vendor name, invoice date and balance due.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll