Here is the script given: Looking for the answer to the advanced challenge question pictured.

CREATE TABLE suppliers (sup_name VARCHAR2(20), description VARCHAR2(100) ); INSERT INTO suppliers VALUES ('Second Hand Reads', 'wholesaler of used books only, located in Chicago, 634.555-8787'); INSERT INTO suppliers VALUES ('Leftovers', 'Physical store location, located in Seattle, willing to fill referred sales, sales@leftovers.com'); INSERT INTO suppliers VALUES ('Read Again', 'Chain of used book store fronts, seeking online sales partner, located in western U.S., 919-555-3333'); INSERT INTO suppliers VALUES ('Bind Savers', 'Used book wholsaler, stock includes international titles, 402-555-2323'); INSERT INTO suppliers VALUES ('Book Recyclers', 'Used book chain, located in Canada, large volume of sales, 888.555.5204'); INSERT INTO suppliers VALUES ('Page Shock', 'Book wholsaler for specialty books and graphic novels, help@pageshock.com'); INSERT INTO suppliers VALUES ('RePage', 'Used book vendor, only wholesales, Wash D.C., 555-0122'); COMMIT; CREATE TABLE contacts (name VARCHAR2(40)); INSERT INTO contacts VALUES('LaFodant,Mike,934-555-3493'); INSERT INTO contacts VALUES('Harris,Annette,727-555-2739'); INSERT INTO contacts VALUES('Crew,Ben,352-555-3638'); COMMIT;

?? @ oracle-1 2c-sal.pdf + O ileI//Users/) oracle 12c_sql.pdf 422 of 627 4. Display a list of all book tities and the percentage of markup for each book. The percentage 399 of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, tollowed by a percent sign (for example, .2793-28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.) 5. Display the current day of the week, hour, minutes, and seconds of the curent date setting 6. Create a list of all book titles and costs. Precede each book's cost with asterisks so that the 7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure each 8. Using today's date, determine the age (in months) of each book that JustLee sells. Make on the computer you're using. width of the displayed Cost field is 12. different length value is displayed only once (not once for each book). sure only whole months are displayed, ignore any portions of months. Display the book title, publication date, current date, and aga. 9. Determine the calendar date of the next occurrence of Wednesday, based on today's date. 10. Produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number, if it exists Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database Management is proposing to increase the price of each book. The amount of the increase will be based on each book's category, according to the following scale: Computer books, 10%; Fitness books, 15%; SeIHelp books, 25%, all other categones, 3%. Create a list that displays each book's titie, category, current retail price, and revised retail price. The prices should be displayed with two decimal places. The column headings for the output should be as follows: Title, Category, Current Price, and Revised Price. Sort the results by category. If there's mone than one book in a category, a secondary sort should be pertormed on the book's title. Create a document lo show management the SELECT statement used to generate the results and the results of the statement Selected Single-Row Functions 1:56 PM O Type here to search ?? @ oracle-1 2c-sal.pdf + O ileI//Users/) oracle 12c_sql.pdf 422 of 627 4. Display a list of all book tities and the percentage of markup for each book. The percentage 399 of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, tollowed by a percent sign (for example, .2793-28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.) 5. Display the current day of the week, hour, minutes, and seconds of the curent date setting 6. Create a list of all book titles and costs. Precede each book's cost with asterisks so that the 7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure each 8. Using today's date, determine the age (in months) of each book that JustLee sells. Make on the computer you're using. width of the displayed Cost field is 12. different length value is displayed only once (not once for each book). sure only whole months are displayed, ignore any portions of months. Display the book title, publication date, current date, and aga. 9. Determine the calendar date of the next occurrence of Wednesday, based on today's date. 10. Produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number, if it exists Advanced Challenge To perform this activity, refer to the tables in the JustLee Books database Management is proposing to increase the price of each book. The amount of the increase will be based on each book's category, according to the following scale: Computer books, 10%; Fitness books, 15%; SeIHelp books, 25%, all other categones, 3%. Create a list that displays each book's titie, category, current retail price, and revised retail price. The prices should be displayed with two decimal places. The column headings for the output should be as follows: Title, Category, Current Price, and Revised Price. Sort the results by category. If there's mone than one book in a category, a secondary sort should be pertormed on the book's title. Create a document lo show management the SELECT statement used to generate the results and the results of the statement Selected Single-Row Functions 1:56 PM O Type here to search