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...

At Ï = 1 rad/s, obtain the input admittance in the circuit of Fig. 9.64. 2 Ww 1 2H 1 F

Durango purchased a new piece of equipment to be used in its new facility. The $370,000 piece of equipment was purchased with a $50,000 down payment and with cash received through the issuance of a...

In an uptrend, prices show a pattern of: A ) Higher highs and higher lows B ) Lower highs and lower lows C ) Flat price movement D ) Decreasing open interest _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+j Explain key learning objectives that drive training programs aimed at

=+3 What do you think is the most significant challenge for IHRM in managing international assignees? Why?

=+Where do you want to live and work?