Please provide SQL statements and screenshots of these statements running in your environment for following reports. If you do not provide any proof for statement running in your environment you will not get a grade for that question. (20 points each) 1) List all the books who have written by SAM SMITH in category FITNESS 2) List all the orders what all the books who have written by SAM SMITH in category FITNESS 3) List all the books that were published by REED-N-RITE. 4) List all the books that were shipped to SEATTLE.

i have 2 part in my ask question because the work its too long to paste here 5) List all the customer firstname and lastname that have books shipped to TX.

plz provide me the code to do that in oracle 12