Homework #$4$ Instructions

Log into your Oracle liveSQL account and open and run the Bookstore database script. Then write and run the following queries:

Query $1$: Write and run an SQL statement to replace the first and last names of any one customer who has purchased books to your own first and last names.

Query $2$: Write and run an SQL statement to generate a report that shows customer's $($your$)$ name $($first and last names combined together with initial letter capitalized$),$ how many different $($unique$)$ books you as a customer purchased, and total amount you spent on purchasing the books. Query output should please look like the following $($though books purchased and total $ spent may be different depending on which customer's name you replaced with your own name$).$ Note: the paideach column in the ORDERITEMS table refers to the retail price that the customer paid for a book.$\backslash$table$[[$Customer$,$Books Purchased,Total $ Spent$],[$Ashraf Shirani,$3,182\mathrm{.}75]]$Log into your Oracle liveSQL account and open and run the Bookstore database script. Then write and run the following queries:

Query $1$: Write and run an SQL statement to replace the first and last names of any one customer who has purchased books to your own first and last names.

Query $2$:

Write and run an SQL statement to generate a report that shows customer's $($your$)$ name $($first and last names combined together with initial letter capitalized$),$ how many different $($unique$)$ books you as a customer purchased, and total amount you spent on purchasing the books. Query output should please look like the following $($though books purchased and total $ spent may be different depending on which customer's name you replaced with your own name$).$ Note: the paideach column in the ORDERITEMS table refers to the retail price that the customer paid for a book.

Create a single screenshot of Query $2$ and its output; make sure your account email is visible in the same screenshot. Paste the screenshot in a Word document.

What to submit: Please upload to Canvas the Word document containing Query $2$ screenshots as described above. The Word document should contain your full name at the top of the document, and Query $2$ screenshot. The screenshot should show the following three items:

$(1)$ complete SQL statement

$(2)$ complete output of the SQL statement

$(3)$ your email account