2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted byeach vendor, who has submitted more than one invoice. Order by the number of invoices in descendingorder. Should return 12 rows.number ofvendor nameaverage_invoice_total min_invoice_total max_invoice_totalinvoicesFederal Exoress CorporationUnited Parcel Service4793.1510.00739.202575.331927.543813.33Zvlka DesianPacific BelMalov Lithoarachina Inc313. 5516.33867.531962. 1328.5046.2123978.4810976.0637966, 1925.67224.00Roadwav Packaoe Svstem. Ic410.926.00Blue CrossComouserveIncramData Reoroductions CorpIBM|Cardinal Business Media. Inc.188.00116.009.959.959.9521077.21579. 421575.0085.31116.5410963.6621842.00600.06132.681083. 5890.36175.00

SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted by each vendor, who has submitted more than one invoice. Order by the number of invoices in descending order. Should return 12 rows. number of vendor name average_invoice_total min_invoice_total max_invoice total invoices Federal Exoress Corporation United Parcel Service Zvlka Desian Pacific Bel Malov Lithoarachina Inc Roadwav Packaoe Svstem. Inc Blue Cross Compuserve Inoram Data Reoroductions Coro IBM Cardinal Business Media. Inc. 47 93. 15 10.00 739.20 9 2575.33 1927.54 3813.33 867.53 313. 55 1962. 13 46.21 28.50 16.33 23978.48 10976.06 37966. 19 10.92 6.00 25.67 188.00 116.00 224.00 9.95 9.95 9.95 1077.21 579. 42 1575.00 2. 10963.66 85.31 21842.00 1083. 58 600.06 116. 54 90.36 132.68 175.00

2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted by each vendor, who has submitted more than one invoice. Order by the number of invoices in descending order. Should return 12 rows. number of vendor name average_invoice_total min_invoice_total max_invoice total invoices Federal Exoress Corporation United Parcel Service Zvlka Desian Pacific Bel Malov Lithoarachina Inc Roadwav Packaoe Svstem. Inc Blue Cross Compuserve Inoram Data Reoroductions Coro IBM Cardinal Business Media. Inc. 47 93. 15 10.00 739.20 9 2575.33 1927.54 3813.33 867.53 313. 55 1962. 13 46.21 28.50 16.33 23978.48 10976.06 37966. 19 10.92 6.00 25.67 188.00 116.00 224.00 9.95 9.95 9.95 1077.21 579. 42 1575.00 2. 10963.66 85.31 21842.00 1083. 58 600.06 116. 54 90.36 132.68 175.00

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).
The code: "SELECT SupplierlD FROM Products Order By SupplierName DESC;" extracts data from Products table and sorts the SupplierName by order. alphabetical reverse alphabetical chronological random
4. Determine which orders had a higher total amount due than order 1008. SQL commands
question 6 please use the picture below to answer the following question Write a SQL statement to define a constraint in the Position table to ensure the column position does not accept duplicates.
Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN_ID DELIVERY DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 10-10-2017 1003 600 12-06-2017 2005 3002 12-08-2017 1004 400.25 10-05-2017 2003 3004 10-07-2017 1005 500.10 03-08-2017 2004 3005 03-05-2017 1006 400 10-07-2017 2005 3006 10-10-2017 Table: PURCHASE _DETAILS ORDER_NO PRODUCT_NAME PRICE QUANTITY 1001 KEYBOARD 56 100 1002 MONITOR 36 200 1003 MOUSE 100 1004 HARD_DISK 58 300 1005 RAM 25 500 1007 CABINET 100 a) Write a SQL query to display PRODUCT_NAME, ORDER DATE and find number of years between the DELIVERY_ DATE from the CURRENT DATE [Hint: Use ON Clause]. b) Write a SQL query to display matched records from PURCHASE_ORDER table and all records from PURCHASE_DETAILS. c) Write an SQL query to display ORDER_NO, PRODUCT_NAME from table ORDER_DETAILS of products where the price is less than average price of products. [Hint: Use Subquery]. d) Write an SQL query to display ORDER_NO,…
how is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed by period b) Table name followed by plus c) Table name followed by equal d) Table name followed by space abd then column name
Write query to create given table 'MAIN'
I need help with this SQL query: Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.
5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
code of create table and insert table only please
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.