SQL Please help me by filling in the 8 ____________ blanks below with the correc

Question

SQL Please help me by filling in the 8 ____________ blanks below with the correct SQL statements. Thank you in advance!!

Fill in the blanks in the SQL statement below that will list invoice_number, vendor name, invoice_total. Use the alias i for invoices and the alias v for vendors.

SELECT invoice_number, name, invoice_total
FROM ___________ , ____________  
WHERE _____________ .invoice_id = _____________ .invoice_id ;

Fill in the blanks in the SQL statement below that will create a view named vendor_invoices which lists invoice_number, vendor name, invoice_date and invoice_total for all invoices.

CREATE VIEW ______________ AS
SELECT invoice_number, name, invoice_date, invoice_total
FROM invoices , ________________
WHERE ___________ .invoice_id = _____________ .invoice_id ;

Accounts Payable Database Listing Description of tables in the AP database Table: general_ledger_accounts general_ledger_accounts(account_number, description) Table: terms terms(terms_id, description, due_days) Table: vendor contacts vendor_contacts(contact_id, last_name, first_name) Table: vendor vendor(vendor_id, name, address1, address2, city, state, zip, phone, contact id, default_terms_id, default_account_number) Table: invoices invoices(vendor_id, number, invoice_date, invoice_total, payment_total, credit_total, terms_id, invoice_due_date, payment_date) Table: invoice_line_items invoice_line_items(invoice_id, sequence, a ccount number, amount, descriptiou

Explanation / Answer

1. SQL statement to list invoice_number, vendor name, invoice_total:

SELECT i.invoice_number, v.name, i.invoice_total
FROM invoices i , vendors v WHERE i.vendor_id = v.vendor_id ;

2. SQL statement that will create a view named
vendor_invoices which lists invoice_number, vendor name, invoice_date and
invoice_total for all invoices.

CREATE VIEW vendor_invoices AS
SELECT i.invoice_number, v.name, i.invoice_date, i.invoice_total
FROM invoices i, vendors v WHERE i.vendor_id = v.vendor_id ;

Note :- The only relation between vendors and invoices table is vendor_id.
There is no relation like , .invoice_id = _____________ .invoice_id

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.