Topic: Databse Prompt: Transform as necessary and then write the XML elements to the appropriate tables in the database.Build SQL chunks for the following queries: What are the titles and prices of...

Topic: Databse

Prompt:

1. Transform as necessary and then write the XML elements to the appropriate tables in the database.Build SQL chunks for the following queries:
   
   
   
   1. What are the titles and prices of all books written by "Galos, Mike"? List the titles and the prices.
   
   
   2. What is the most recent year of publication of all books written by "O'Brien, Tim".
   
   
   3. What is the average price of all books in the "Fantasy" genre.
   
   
   4. Find the number of books in each genre.
   
   
   5. List the title and author of all books that cost less than the average price of books.
   
   
   
   

XML Syntax:

Gambardella, Matthew

      XML Developer's Guide

Computer

44.95

2000-10-01

Ralls, Kim

      Midnight Rain

Fantasy

5.95

2000-12-16

Corets, Eva

      Maeve Ascendant

Fantasy

5.95

2000-11-17

Corets, Eva

      Oberon's Legacy

Fantasy

5.95

2001-03-10

Corets, Eva

      The Sundered Grail

Fantasy

5.95

2001-09-10

Randall, Cynthia

      Lover Birds

Romance

4.95

2000-09-02

Galos, Mike

      Visual Studio

Computer

69.95

2008-09-01

Thurman, Paula

      Splish Splash

Romance

4.95

2000-11-02

Knorr, Stefan

      Creepy Crawlies

Horror

4.95

2000-12-06

Kress, Peter

      Paradox Lost

Science Fiction

6.95

2000-11-02

Galos, Mike

      Visual Basic for Beginners

Computer

29.95

2004-05-20

O'Brien, Tim

      Microsoft .NET: The Programming Bible

Computer

36.95

2000-12-09

O'Brien, Tim

      MSXML3: A Comprehensive Guide

Computer

36.00

2005-12-01

O'Brien, Tim

      MSXML3: A Comprehensive Guide

2

Computer

36.00

2009-10-01

Galos, Mike

      Visual Studio 7: A Comprehensive Guide

Computer

49.95

2001-04-16

Corets, Eva

      Oberon's Revenge

Fantasy

7.95

2004-06-01