1. In the MySQL shell, use your book_shop database and books table you created from 08.books_db.sql 2. Create and name a new file '09.strings.sql' and complete the following tasks: a. Use string functions to reverse and uppercase the following sentence (at the same time): "Why does my cat look at me with such hatred?" b. Produce the following output: + + | title | The->Namesake | Norse->Mythology | American->Gods | Interpreter ->of ->Maladies | A->Hologram->for->the->King:->A->Novel | The->circle | The->Amazing->Adventures->of->Kavalier->&->clay | Just->Kids | A->Heartbreaking->Work->of->staggering->Genius: | Coraline | What->We->Talk->About->when->We->Talk->About ->Love: ->stories | Where->I'm->calling->From:->Selected->stories | white->Noise | Cannery->ROW | Oblivion:->stories | Consider->the->Lobster + | backwards Produce the following output: +- | forwards +- | Lahiri | Gaiman | Gaiman | Lahiri | Eggers 1 | irihal | namiag | namiag | irihal | sregge | Eggers | sregge | | chabon | nobahc | Smith | htims | Eggers | sregge | Gaiman | namiag | Carver | revrac | Carver | revrac | DeLillo | olliLeD | steinbeck | kcebniets 1 | Foster Wallace | ecallaw retsoF | | Foster Wallace | ecallaw retsoF | + d. Produce the following output: +-- | full name in caps +- | JHUMPA LAHIRI | NEIL GAIMAN | NEIL GAIMAN | JHUMPA LAHIRI | DAVE EGGERS | DAVE EGGERS | MICHAEL CHABON | PATTI SMITH | DAVE EGGERS | NEIL GAIMAN | RAYMOND CARVER | RAYMOND CARVER | DON DELILLO | JOHN STEINBECK 1 | DAVID FOSTER WALLACE | | DAVID FOSTER WALLACE - + e. Produce the following output: | blurb | The Namesake was released in 2003 | Norse Mythology was released in 2016 American Gods was released in 2001 | Interpreter of Maladies was released in 1996 | A Hologram for the king: A Novel was released in 2012 | The circle was released in 2013 | The Amazing Adventures of Kavalier & clay was released in 2000 | Just Kids was released in 2010 | A Heartbreaking work of staggering Genius: was released in 2001 | Coraline was released in 2003 What We Talk About When We Talk About Love: stories was released in 1981 | Where I'm calling From: Selected stories was released in 1989 | White Noise was released in 1985 | Cannery Row was released in 1945 Oblivion: Stories was released in 2004 | consider the Lobster was released in 2005 f. Produce the following output: | title | character count 12 | 15 13 23 32 10 41 | The Namesake | Norse Mythology American Gods | Interpreter of Maladies | A Hologram for the king: A Novel | The circle The Amazing Adventures of Kavalier & clay Just Kids | A Heartbreaking work of staggering Genius: | Coraline | What We Talk About When We Talk About Love: Stories | | Where I'm calling From: Selected stories white Noise Cannery Row | oblivion: stories | Consider the Lobster 9 42 8 51 40 11 11 17 20 g. Produce the following output (you only need 1 condition): + + | short title | author | quantity | | American G... | Gaiman, Neil | 12 in stock | A Heartbre... | Eggers, Dave | 104 in stock 1. In the MySQL shell, use your book_shop database and books table you created from 08.books_db.sql 2. Create and name a new file '09.strings.sql' and complete the following tasks: a. Use string functions to reverse and uppercase the following sentence (at the same time): "Why does my cat look at me with such hatred?" b. Produce the following output: + + | title | The->Namesake | Norse->Mythology | American->Gods | Interpreter ->of ->Maladies | A->Hologram->for->the->King:->A->Novel | The->circle | The->Amazing->Adventures->of->Kavalier->&->clay | Just->Kids | A->Heartbreaking->Work->of->staggering->Genius: | Coraline | What->We->Talk->About->when->We->Talk->About ->Love: ->stories | Where->I'm->calling->From:->Selected->stories | white->Noise | Cannery->ROW | Oblivion:->stories | Consider->the->Lobster + | backwards Produce the following output: +- | forwards +- | Lahiri | Gaiman | Gaiman | Lahiri | Eggers 1 | irihal | namiag | namiag | irihal | sregge | Eggers | sregge | | chabon | nobahc | Smith | htims | Eggers | sregge | Gaiman | namiag | Carver | revrac | Carver | revrac | DeLillo | olliLeD | steinbeck | kcebniets 1 | Foster Wallace | ecallaw retsoF | | Foster Wallace | ecallaw retsoF | + d. Produce the following output: +-- | full name in caps +- | JHUMPA LAHIRI | NEIL GAIMAN | NEIL GAIMAN | JHUMPA LAHIRI | DAVE EGGERS | DAVE EGGERS | MICHAEL CHABON | PATTI SMITH | DAVE EGGERS | NEIL GAIMAN | RAYMOND CARVER | RAYMOND CARVER | DON DELILLO | JOHN STEINBECK 1 | DAVID FOSTER WALLACE | | DAVID FOSTER WALLACE - + e. Produce the following output: | blurb | The Namesake was released in 2003 | Norse Mythology was released in 2016 American Gods was released in 2001 | Interpreter of Maladies was released in 1996 | A Hologram for the king: A Novel was released in 2012 | The circle was released in 2013 | The Amazing Adventures of Kavalier & clay was released in 2000 | Just Kids was released in 2010 | A Heartbreaking work of staggering Genius: was released in 2001 | Coraline was released in 2003 What We Talk About When We Talk About Love: stories was released in 1981 | Where I'm calling From: Selected stories was released in 1989 | White Noise was released in 1985 | Cannery Row was released in 1945 Oblivion: Stories was released in 2004 | consider the Lobster was released in 2005 f. Produce the following output: | title | character count 12 | 15 13 23 32 10 41 | The Namesake | Norse Mythology American Gods | Interpreter of Maladies | A Hologram for the king: A Novel | The circle The Amazing Adventures of Kavalier & clay Just Kids | A Heartbreaking work of staggering Genius: | Coraline | What We Talk About When We Talk About Love: Stories | | Where I'm calling From: Selected stories white Noise Cannery Row | oblivion: stories | Consider the Lobster 9 42 8 51 40 11 11 17 20 g. Produce the following output (you only need 1 condition): + + | short title | author | quantity | | American G... | Gaiman, Neil | 12 in stock | A Heartbre... | Eggers, Dave | 104 in stock