Hello! Need some help with these quieries! I've included the questions and the invoice colums and vendors column from my database. Thanks! CIS111 Chapter 5 Lab Problems3. Display the vendor name, number of invoices, average and total invoice for any vendorthat has more than 2 invoices. Please show the total of each column in the bottom row.Please use the following column aliases:Number of InvoicesInvoice AverageInvoice Total4. Display the vendors state, city, the invoice total for all vendors Whose average invoice isover 3000 dollars. Please report the total of each state also. Please do not include(remove) the state of California from the output. ery4.sc...CONNECTIONSV SERVERSBB日UserE dbo.invoicelineltemsD Rum dbo.InvoicesColumns8 InvoicelD (PK, int, not null)E vendoriD (FK, int, not null)E InvoiceNumber (varchar(50), not null)E InvoiceDate (smalldatetime, not null)E InvoiceTotal (money, not null)E PaymentTotal (money, not null)E CreditTotal (money, not nul)E TermsID (FK, int, not null)B InvoiceDueDate (smalldatetime, not null).E PaymentDate (smalldatetime, null)> KeysMessa3Constraints> TriggersIndexesStatistics> m dbo.Termsm dbo VendorsColumnsE VendoriD (PK, int, not null)E VendorName (varchar(50), not null)E VendorAddresst (varchar(50), nul)E vendorAddress2 (varchar(50), null)PROE vendorCity (varchar(50), not null)E vendorState (char(2), not null)E Vendorzipcode (varchar(20), not nul)E vendorPhone (varchar(50), null)NoE VendorContactLName (varchar(50), null)E VendorContactFName (varchar(50), null)E DefaultTermsID (FK, int, not null)E DefaultAccountNo (FK, int, not null)Keys> AZURE> SOL SERVER BIG DATA CLUSTERSO 6 A0

The following example shows three code examples. This first code example returns all rows (no WHERE…

CIS111 Chapter 5 Lab Problems 3. Display the vendor name, number of invoices, average and total invoice for any vendor that has more than 2 invoices. Please show the total of each column in the bottom row. Please use the following column aliases: Number of Invoices Invoice Average Invoice Total 4. Display the vendors state, city, the invoice total for all vendors Whose average invoice is over 3000 dollars. Please report the total of each state also. Please do not include (remove) the state of California from the output.

CIS111 Chapter 5 Lab Problems 3. Display the vendor name, number of invoices, average and total invoice for any vendor that has more than 2 invoices. Please show the total of each column in the bottom row. Please use the following column aliases: Number of Invoices Invoice Average Invoice Total 4. Display the vendors state, city, the invoice total for all vendors Whose average invoice is over 3000 dollars. Please report the total of each state also. Please do not include (remove) the state of California from the output.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

What are the advantages and disadvantages of using Oracle versus SQL?
Use the content of the AdventureWorks sample database. Identify and explain which field on what table tells you whether a product will be built or bought?
When creating tables in Microsoft Access, how do we decide which model to create?
You should provide a real-world example of a SQL database and explain how it works.
To manage and manipulate the test table what are the SQL statements that you have used in Database testing?