Using the ap database: Write a SELECT statement that returns one row for each vendor that...

 

Transcribed Image Text:

Using the ap database: Write a SELECT statement that returns one row for each vendor that contains three columns: • The vendor_name column from the Vendors table • The count of the invoices in the Invoices table for each vendor • The sum of the invoice total columns in the Invoices table for each vendor Fill in the missing keywords: [1. Fill in missing piece] vendor_name, [2. Fill in missing piece] AS invoice_count, [3. Fill in missing piece] AS invoice_total_sum [4. Fill in missing piece] vendors v [5. Fill in missing piece] invoices i [6. Fill in missing piece] v.vendor_id = i.vendor_id [7. Fill in missing piece] vendor_name [8. Fill in missing piece] invoice_count [9. Fill in missing piece]; Using the ap database: Write a SELECT statement that returns one row for each vendor that contains three columns: • The vendor_name column from the Vendors table • The count of the invoices in the Invoices table for each vendor • The sum of the invoice total columns in the Invoices table for each vendor Fill in the missing keywords: [1. Fill in missing piece] vendor_name, [2. Fill in missing piece] AS invoice_count, [3. Fill in missing piece] AS invoice_total_sum [4. Fill in missing piece] vendors v [5. Fill in missing piece] invoices i [6. Fill in missing piece] v.vendor_id = i.vendor_id [7. Fill in missing piece] vendor_name [8. Fill in missing piece] invoice_count [9. Fill in missing piece];

Answer rating: 100% (QA)

Based on the given image you are trying to construct a SQL SELECT statement to acquire information f... View the full answer