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)List the title and prices of all books in the "Computer" genre.What is the number of all books that cost less than $5? (Use the count aggregation function) Вooks-v3.xmlGambardella, MatthewXML Developer's GuideComputer44.952000–10–01An in-depth look at creating applicationswith XML.Rals, KimMidnight RainFantasy5.952000–12–16A_former architect battles corporate zombies,an evil sorceress, and her own childhood to become queenof the world.Corets, EvaMaeve AscendantFantasy5.952000–11–17After the collapse of a nanotechnologysociety in England, the young survivors lay thefoundation for a new society.Corets, Eva0beron's LegacyFantasy5.952001–03–10In post-apocalypse England, the mysteriousagent known only as Oberon helps to create a new lifefor the inhabitants of London. Sequel to MaeveAccondant

According our policy we give answer first three…

Answered: write XPath expressions in an R…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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)
List the title and prices of all books in the "Computer" genre.
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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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