give me the .sql file queries (no need the file just screenshot of what you have inputted in your sql database live environment) and then screenshot the output of the .lst file after generating the .sql file to .st file please! thank you so much it's quite u..>@showplan.sql contains this:  

 

Task 4 (4 marks) An objective of this task is to improve performance of query processing through indexing. In this task you must operate on the original state of a sample benchmark TPC-HR database. It is explained at the end of Prologue section how to return to the original state of the database. Consider the following templates of SELECT statements where a string of characters... denotes any syntactically valid constant that can be used a statement. (1) SELECT L_DISCOUNT, L_TAX, L_ORDERKEY FROM LINEITEM JOIN ORDERS ON LINEITEM.L_ORDERKEY = ORDERS.O_ORDERKEY WHERE ORDERS.O TOTALPRICE = ...; (2) SELECT L DISCOUNT, L TAX, L_ORDERKEY FROM LINEITEM JOIN PRTSUPP ON LINEITEM. L PARTKEY = PARTSUPP. PS PARTKEY AND (4) LINEITEM.L_SUPPKEY= PARTSUPP.PS_SUPPKEY WHERE PARTSUPP.PS AVAILOTY = ...; (3) SELECT ORDERS.O TOTALPRICE, ORDERS. O_ORDERKEY FROM ORDERS WHERE ORDERS.O_TOTALPRICE = ... EXPLAIN PLAN FOR SELECT AVG (L_DISCOUNT), AVG (L_TAX) FROM LINEITEM WHERE L DISCOUNT > ... AND L_TAX > ... An objective of this task is to create two indexes that improve processing of the queries listed above in the best possible way. Implement SQL script solution 3.sql that performs the actions listed below. (1) First, the script finds the query processing plans for each one of the queries listed above. Use EXPLAIN PLAN statement and a script showplan.sql to display the query processing plans.