What is the description of this database SELECT invoice_number,vendor_name,’33%P

Question

What is the description of this database

SELECT invoice_number,vendor_name,’33%Payment’ASpayment_type,invoice_total *0.333 AS payment

       FROM invoices JOIN vendors ON vendors.vendor_id=vendors.vendor_id

       WHERE invoice_total>1000

UNION

SELECT invoice_number,vendor_name,‘50% Payment’ASpayment_type,invoice_total *0.5 AS payment

       FROM invoices JOIN vendors ON vendors.vendor_id=vendors.vendor_id

       WHERE invoice_total>1000 BETWEEN 500 AND 1000

UNION

      SELECT invoice_number,vendor_name,‘FULL amount’AS   payment_type,invoice_total AS total,invoice_total AS payment

       FROM invoices JOIN vendors ON invoices vendors.id=vendors.vendor_id

       WHERE invoice_total<500

ORDER BY payment_type,vendor_name,invoice_number

Explanation / Answer

What is the description of this database?

  While looking into the Query and the variables used in the query, the table is about Account Payable Listings. The Reason why it was considered as account payable was it has the following terms

1. Invoice

2. Payment

3. Vendor.

So we concluded here that, Below are the description of tables that can be used.

1. Invoices

2. Vendor

3. Payment.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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