Question: I am trying to write a query to Write a subquery to return one row per vendor, representing the vendors earliest invoice_due_date. Each row should

I am trying to write a query to "Write a subquery to return one row per vendor, representing the vendors earliest invoice_due_date. Each row should include ( vendor name, vendor_id, count of invoices, the earliest invoice due date. Filter the result set to only show the rows with more than 3 count of invoices." This is my query so far

select i.vendor_name, i.vendor_id, count(invoice_id) as number_of_invoices, min(invoice_due_date) as earliest_due_date

from vendors i join

(select vendor_id, count(invoice_id) as number_of_invoices, min(invoice_due_date) as earliest_due_date

from invoices

group by vendor_id

having count(invoice_id) > 3) v

on i.VENDOR_ID = v.VENDOR_ID

group by i.VENDOR_ID, i.vendor_name;

I get this error "

ORA-00904: "INVOICE_DUE_DATE": invalid identifier

00904. 00000 - "%s: invalid identifier"

*Cause:

*Action:

Error at Line: 1 Column: 81"

NOTE: the vendor name column belongs to the vendors table and the vendor_id is the primary key in the vendors table and a foreign key in the invoices table. All other columns belong to invoices table.

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 Databases Questions!

I am trying to write a query to "Write a subquery to return one row per vendor, representing the vendors earliest invoice_due_date. Each row should include ( vendor name, vendor_id, count of...

Write a subquery to return one row per vendor, representing the vendors earliest invoice_due_date. Each row should include ( vendor name, vendor_id, count of invoices, the earliest invoice due date....

THIS IS AN SQL PROBLEM PLEASE SHARE CODE AND RESULT FROM QUERY 6. Write a SELECT statement that returns a single value that represents the sum of the largest unpaid invoices submitted by each vendor....

This is an SQL problem. Please share the CODE AND THE RESULT from SQL. 6. Write a SELECT statement that returns a single value that represents the sum of the largest unpaid invoices submitted by each...

Using MYSQL Write a SELECT statement that returns three columns: email_address, order_id, and the order total for each customer. To do this, you can group the result set by the email_address and...

Chapter 7: How to Code Subqueries Write a SELECT statement that returns three columns: email_address, order_id, and the order total for each customer. To do this, you can group the result set by the...

1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword. SELECT DISTINCT...

1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword. SELECT DISTINCT vendor...

Show the products of thesereactions: CH NaOH Br2 Bra b) a) . .

A company reports the following: Net income .............$ 210,000 Preferred dividends ...........30,000 Average stockholders equity ......1,750,000 Average common stockholders equity ...1,000,000...

A natural person with at least $5 million in investments meets the definition of A) a qualified client. Incorrect Answer B) an institutional investor. Incorrect Answer C) an accredited investor....

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Do you generate agendas with the dates, places, and times for the next meetings?

a. How will the leader be selected?

4. Trust develops with shared experience, values, give-and-take, and the result of human communication. Satellites, electronic mail, and networks could reduce the dimensions of trust to which we are...