write XPath expressions in an R Notebook that evaluate the following queries; display the results in your R Notebook. What are the titles of all books written by "Galos, Mike"? List the titles and the prices. In what genre is the book with id "bk109". What are the titles of the books that sell for the lowest price? (Use the min aggregation function)

Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter6: Business Intelligence And Analytics
Section: Chapter Questions
Problem 1WE
icon
Related questions
Question

write XPath expressions in an R Notebook that evaluate the following queries; display the results in your R Notebook. 

  1. What are the titles of all books written by "Galos, Mike"? List the titles and the prices.
  2. In what genre is the book with id "bk109".
  3. What are the titles of the books that sell for the lowest price? (Use the min aggregation function)
  4. List the title and prices of all books in the "Computer" genre.
  5. What is the number of all books that cost less than $5? (Use the count aggregation function)

 

Вooks-v3.xml
<?xml version="1.0"?>
<catalog>
<book id="bk101">
<author>Gambardella, Matthew</author>
<title>XML Developer's Guide</title>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000–10–01</publish_date>
<description>An in-depth look at creating applications
with XML.</description>
</book>
<book id="bk102">
<author>Rals, Kim</author>
<title>Midnight Rain</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000–12–16</publish_date>
<description>A_former architect battles corporate zombies,
an evil sorceress, and her own childhood to become queen
of the world.</description>
</book>
<book id="bk103">
<author>Corets, Eva</author>
<title>Maeve Ascendant</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000–11–17</publish_date>
<description>After the collapse of a nanotechnology
society in England, the young survivors lay the
foundation for a new society.</description>
</book>
<book id="bk104">
<author>Corets, Eva</author>
<title>0beron's Legacy</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2001–03–10</publish_date>
<description>In post-apocalypse England, the mysterious
agent known only as Oberon helps to create a new life
for the inhabitants of London. Sequel to Maeve
Accondant
Transcribed Image Text:Вooks-v3.xml <?xml version="1.0"?> <catalog> <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000–10–01</publish_date> <description>An in-depth look at creating applications with XML.</description> </book> <book id="bk102"> <author>Rals, Kim</author> <title>Midnight Rain</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2000–12–16</publish_date> <description>A_former architect battles corporate zombies, an evil sorceress, and her own childhood to become queen of the world.</description> </book> <book id="bk103"> <author>Corets, Eva</author> <title>Maeve Ascendant</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2000–11–17</publish_date> <description>After the collapse of a nanotechnology society in England, the young survivors lay the foundation for a new society.</description> </book> <book id="bk104"> <author>Corets, Eva</author> <title>0beron's Legacy</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2001–03–10</publish_date> <description>In post-apocalypse England, the mysterious agent known only as Oberon helps to create a new life for the inhabitants of London. Sequel to Maeve Accondant
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning