Create SQL queries DATABASE SCHEMA: VENDOR {VENDOR_ID,VENDOR_NAME,VENDOR_CITY,VE

ID: 640337 • Letter: C

Question

Create SQL queries

DATABASE SCHEMA:

VENDOR {VENDOR_ID,VENDOR_NAME,VENDOR_CITY,VENDOR_STATE}

INVOICE{INVOICE_ID,VENDOR_ID,INVOICE_DATE,INVOICE_TOTAL,PAYMENT_TOTAL,CREDIT_TOTAL}

EXPECTED OUTPUT:

1) List the vendor name and city/state where there is only one vendor in that city and state.

2) List the TOP 5 invoices based on highest balance due.

Give the vendor name, invoice date and balance due.

3) List the TOP 10 PERCENT of the invoices based on highest balance due.

Give the vendor name, invoice date and balance due.

SQL EXAMPLE

SQL> CREATE TABLE VENTOR1

(VENDOR_ID NUMBER(20),

VENDOR_NAME VARCHAR(20),

VENDOR_CITY VARCHAR(20),

VENDOR_STATE VARCHAR(20));

Table created

SQL> CREATE TABLE INVOICE1

(INVOICE_ID NUMBER(20),

VENDOR_ID NUMBER(20),

INVOICE_DATE DATE,

INVOICE_TOTAL NUMBER(20),

PAYMENT_TOTAL NUMBER(20),

CREDIT_TOTAL NUMBER(20));

Table created

SQL> INSERT INTO VENTOR1(VENTOR_ID,VENTOR_NAME,VENTOR_CITY,VENDOR_STATE) VALUES(01,