Consider the following code example SELECT i vendor id , MAX ( i invoice total ) AS largest invoice FROM invoices i JOIN ( SELECT vendor id , AVG ( invoice total ) AS average invoice FROM invoices GROUP BY vendor id HAVING AVG ( invoice total ) 1 0 0 ) ia ON i vendor id ia vendor id GROUP BY i vendor id ORDER BY largest invoice DESC When this query is executed, each row in the result table will show Consider the following code example SELECT i vendor id , MAX ( i invoice total ) AS largest invoice FROM invoices i JOIN ( SELECT vendor id , AVG ( invoice total ) AS average invoice FROM invoices GROUP BY vendor id HAVING AVG ( invoice total ) 1 0 0 ) ia ON i vendor id ia vendor id GROUP BY i vendor id ORDER BY largest invoice DESC When this query is executed, each row in the result table will show the largest invoice total related to that row the average invoice total related to that row the largest invoice total related to that row, but only if it s larger than the average for all invoices the average invoice total related to that row, but only if it s greater than 1 0 0

The Answer is in the image, click to view ...

Question: Consider the following code example: SELECT i . vendor _ id , MAX ( i . invoice _ total ) AS largest _ invoice FROM

Consider the following code example:

SELECT i

.

vendor

_

,

MAX

(

.

invoice

_

total

)

AS largest

_

invoice

FROM invoices i

JOIN

(

SELECT vendor

_

,

AVG

(

invoice

_

total

)

AS average

_

invoice

FROM invoices

GROUP BY vendor

_

HAVING AVG

(

invoice

_

total

) > 100)

ON i

.

vendor

_

=

.

vendor

_

GROUP BY i

.

vendor

_

ORDER BY largest

_

invoice DESC

When this query is executed, each row in the result table will show

.

Consider the following code example:

SELECT i

.

vendor

_

,

MAX

(

.

invoice

_

total

)

AS largest

_

invoice

FROM invoices i

JOIN

(

SELECT vendor

_

,

AVG

(

invoice

_

total

)

AS average

_

invoice

FROM invoices

GROUP BY vendor

_

HAVING AVG

(

invoice

_

total

) > 100)

ON i

.

vendor

_

=

.

vendor

_

GROUP BY i

.

vendor

_

ORDER BY largest

_

invoice DESC

When this query is executed, each row in the result table will show

.

the largest invoice total related to that row

the average invoice total related to that row

the largest invoice total related to that row, but only if it

s larger than the average for all invoices

the average invoice total related to that row, but only if it

s greater than

100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

SELECT vendor _ name, COUNT ( * ) AS number _ of _ invoices, MAX ( invoice _ total - payment _ total - credit _ total ) AS balance _ due FROM vendors v JOIN invoices i ON v . vendor _ id = i . vendor...

WITH Top5 AS (SELECT TOP 5 VendorID, AVG(InvoiceTotal) AS AvgInvoice FROM Invoices GROUP BY VendorID ORDER BY AvgInvoice DESC) SELECT Invoices. Vendor ID, MAX (Invoices. InvoiceTotal) AS...

SQL Consider the query shown. SELECT vendor id, invoice number, invoice total FROM invoices inv_main WHERE invoice total > (SELECT AVG(invoice_total) FROM invoices inv_sub WHERE inv sub.vendor id inv...

26 The col umn definition for a MySQL table can be used to determine all but one of the following. Which one is it? a. what type of data the column can contairn b. whether the col1 umn can contain a...

QUESTION 1 Assuming that all of the table and column sames are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO invoices (vendor id, invoice number, invoice total,...

here are rhe six inquiry queries the six examples queries the following questions need to be answered: what is each query requesting from the database give a description of the following SQL keywords...

Hello I am using MySQL AP Database. Please help answer questions below. 1. (15 pts) Write a SELECT statement that returns: - the Vendor Name - InvoiceCount: the number of invoices for that Vendor -...

H Complete exercise # 3 through 7. I have question 1,2,3 and 8 complete. see attached pic 3 should help. SQL 2017 AP DATABASE FILE Chapter 4 How to retrieve data from two or more tables Generate the...

Question 17 (2.5 points) The CREATE DATABASE statement creates two files on the hard drive of the server: a data file and a index file log file key file none of the above Question 18 (2.5 points) If...

*Using ap SELECT * FROM ap.invoices; SELECT * FROM ap.general_ledger_accounts; SELECT * FROM ap.invoice_line_items; SELECT * FROM ap.vendors; *using MYSQL ap.sql Exercises 1. Write a SELECT statement...

In the past, most experiments in particle physics involved stationary targets: one particle (usually a proton or an electron) was accelerated to a high energy E, and collided with a target particle...

JZ Church Furniture manufactures custom pews, altars, and pulpits for churches across the southern United States. Since each order is unique, JZ uses a job order costing system. During the month of...

9. Indicate how unrealized holding gains and losses should be reported for investments classified as (a) trading (b) held-for-collection, and (c) held-for-collection and selling.

1 The Kano Model focuses your attention on how customers will react to different features and invites you to compare | each possible feature based on which two criteria? Cost breakdown and price...