All the tables you need for part b is created in the database.

the table you need is already created in the database

You should query from the existing tables in your database.

It's a SQL DATABASE

It's already built in the Oracle SQL Developer database.

Determine the SQL statements needed to perform the two required tanks below. Each statement should be tested to ensure validity Submit your SQL command AND screenshot as documentation of your results for full credit. Remember to include your comments to explain your sql commanda! 1. Create a list from the Customers table that should display the same, address, city, state, and zip code for each customer Each customer's name should be listed in order format of lost me followed by first name, separated with a comma, AND have the column header "Cunomer's Name" Customer's Address":"Cursome' State""Cuitone Zip code For example at first s doplayed in the column bendera Customers" Add diplayed in the ear colleaders "Customer's Adds, and so on. 25 points) ons 2. Management needs to determine proti pe book to determine the percentage of profit for a particulatiem, subtract the item controm the retail price to calculate the dollar amont of profit by the tem's con The solutions then pled by 100 to determine the profita for each book Use SELECT atement to displaysch bookside and profit for the coldplay the percentage CTEC 3000 Proin the combacing 25 points)