1 write a selct statement that returns five columns from three tables all using col 5347023
#1. Write a SELCT statement that returns five columns from three tables, all using column aliases:
Vendor VendorName column
Date InvoiceDate column
Number InvoiceNumber column
# InvoiceSequence column
LineItem InvoiceLineItemAmount column
Assign the following correlation names to the tables:
v Vendor table
i Invoices table
li InvoiceLineItems table
Sort the final result set by Vendor, Date, Number, and #.
#2. Write a SELECT statement that returns three columns:
VendorID From the Vendors table
VendorName From the Vendors table
Name A concatenation of VendorContactFName and VendorContactLName, with a space in between
The result set should have one row for each vendor whose contact has the same first name as another vendor