Write a query to show each author’s first name and last name, along with average retail price of books written by the author.

·         Create a new Word document and type your full name at the top of the document.

·         Login to your livesql.oracle.com account. Run the bookstore.sql script available on Canvas (Files > Data Files folder).

·         Write and run the two queries described below. For each query, create a screenshot of the query and its output, and paste it into the Word document. Each screenshot should show (1) your account e-mail address (2) complete SQL statement (3) complete output of the SQL statement.

Query 1:

Write a query to modify one record in the AUTHOR table. This query should change first name and last name of any one of the authors to your own first name and last name. Run the query, generate its output, and create a screenshot. (Partial output of the query appears below for your reference – your screenshot should show all three things highlighted above in yellow).

Query 2:

Write a query to show each author’s first name and last name, along with average retail price of books written by the author.  (The retail column in BOOKS table contains retail price of a book). Run the query, generate its output, and create a screenshot. (Partial output of the query appears below for your reference – your screenshot should show all three things highlighted above in yellow). Please note the column captions are properly formatted and the average price is rounded to two decimal places.)

Upload your completed HW4 Word document to Canvas.