Question
Problems 1. List all vendors. 2. List Customers who do not have a middle initial. 3. List products from oldest to newest (by indate). 4.
Problems
1. List all vendors.
2. List Customers who do not have a middle initial.
3. List products from oldest to newest (by indate).
4. List the product code, description and price that are saws.
5. List vendors who are not in areacode 615.
6. Count the number of Orders.
7. Count the number of Vendors.
8. What is the total accounts receivable?
9. What is the total amount (revenue) of all invoices?
10. What is the total value of assets in inventory?
11. List the order quantity (in descending order) by product. Include the product number.
12. List invoice totals in descending order of invoice number. Include the invoice number.
13. List invoice totals in descending order of invoice number only if the total is more than $100.
14. List the number of vendors per state. Include the state.
15. List the state with the highest number of vendors. Hint: You may use LIMIT.
Here are the tables that are used:
Goal Use MYSQL Warkbench to write SQL queries to answer the problems below. Procedure - Create a new Wora document. - The first few lines of your Word document should be: - Your Name - ITP 249 - HW 5 - Connect to the ITP MYSQL server from MYSql Warkbench - Run each query below in MYSQL Warkbench against the Solesce database. Do not use your own database that you built in a previaus assignment - Alias calculated/aggregated columns - Insert the SQL query (text) in the Word document. - Screenshot the query results into the Word document. - Save the dacument as lastname_firsthame_HW5. Submit the file on Blackbaard. Problems 1. List all vendars. 2. List Customers who da not have a middle initial. 3. List products from oldest to newest (by indate). 4. List the product code, deseription and price that are saws. 5. List vendors who are not in areagoge 615 . 6. Count the number of Orders. 7. Count the number of Vendors. 8. What is the total accounts receivoble? 9. What is the total amount (revenue) of all imvoices? 10. What is the total value of assets in inventory? 11. List the order quantity fin descending order) by product. Include the product number. 12. List invoice totals in descending order of invoice number. Include the invoice number. 13. List invoice totals in descending order af invoice number only if the total is more than $100. 14. List the number of vendors per state. Include the state. 15. List the state with the highest number of vendors. Hint: You may use LIMIT. \begin{tabular}{llllllll} SQL File 3 & customer x & employee grade invoice line product vendor \\ \hline \end{tabular} salesco Tables customer employee grade invoice line product vendor Views Stored Procedures Functions salesco Tables customer employee grade invoice line product vendor Views Stored Procedures Functions salesco Tables customer employee grade invoice line product vendor Views Stored Procedures Functions salesco Tables customer employee grade invoice line product. vendor Views Stored Procedures Functions FunctionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started