Book BOOK CODE TITLE TYPE PRICE PAPERSACE 0180 0189 0200 0378 029 OSOS 1351 1382 135X PUBLISHER COOP TB FA VE 55 PU A Deepness in the Sky Magic Terror The Stranger Venice Second Wind The Edge Dreamcatcher: A Nyel Treasure Chests Beloved Harry Potter and the Prisoner Van Gogh and Gauguin 5 HOR FIC ART MYS MYS HOR ART 7.19 7.99 8.00 24 50 24.95 6.99 19.60 24.46 12.95 Y y Y N N Y N TA PL FIC N Y 2226 ST SFI 13.96 N 2281 WP ART 21.00 N 1- Write a code to display all tities that begin with and have in the middle 2. Write a code to display the title and publisher code for books with price between $15.00 and $25.00 3. Write a code to display book code and title for publishers: TB, TA, VB, SS and PL 4. Write a code to display the title type and a new column named NEW PRICE (equals to price minus 5) for all books with a price exceeding $15.00 5. Write a code to display the code and title of the ART books, Good luck Book BOOK CODE TITLE TYPE PRICE PAPERSACE 0180 0189 0200 0378 029 OSOS 1351 1382 135X PUBLISHER COOP TB FA VE 55 PU A Deepness in the Sky Magic Terror The Stranger Venice Second Wind The Edge Dreamcatcher: A Nyel Treasure Chests Beloved Harry Potter and the Prisoner Van Gogh and Gauguin 5 HOR FIC ART MYS MYS HOR ART 7.19 7.99 8.00 24 50 24.95 6.99 19.60 24.46 12.95 Y y Y N N Y N TA PL FIC N Y 2226 ST SFI 13.96 N 2281 WP ART 21.00 N 1- Write a code to display all tities that begin with and have in the middle 2. Write a code to display the title and publisher code for books with price between $15.00 and $25.00 3. Write a code to display book code and title for publishers: TB, TA, VB, SS and PL 4. Write a code to display the title type and a new column named NEW PRICE (equals to price minus 5) for all books with a price exceeding $15.00 5. Write a code to display the code and title of the ART books, Good luck