((

Query Assignment

Write the SQL query to answer the following:

Exercises 4 from book "murach's Oracle SQL and PL/SQL for developers)))

* Write a SELECT statement that returns five columns from three tables:

Invoice_namer vender_name from the vedors table

invoice_date invoice_date from the invoices table

invoice_number invoice_number from the invoices table

li_sequence invoice_sequence from the invoice_Line_Items table

li_amount invoice_item_amt from the invoice_Line_Items table

Use these aliases for the tables: Ven for the Vendors table, Inv for the Invoices table , and LI for the Invoice_Line_Items table.Also, sort the final result set dy vendor_name, invoice_data,invoice_number,and invoice_sequence.

(((

Submit a single WORD file that contains the SQL statement and a screen capture of the results (as much as can fit on a single page) for each of the exercises.

)))

please , can you explain step by step

thanks