QUESTION 1Consider the following database schema designed to store information about Books, and Chapters. Book (BookID, BookTitle, Price)BookChapter (ChapterID, BookID, ChapterTitle, NoPages) Write the following queries in SQL.1. Display BookTitle of the most expensive Book ( i.e. the Book with the highest Price).2. For each BookID, display the average NoPages. Consider the following database schema designed to store information about Books, and Chapters.Book (BooklD, BookTitle, Price)BookChapter (ChapterID, BooklD, ChapterTitle, NoPages)Write the following queries in SQL.1. Display BookTitle of the most expensive Book (i.e. the Book with the highest Price).2. For each BooklD, display the average NoPages.For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).BI U SParagraphArial10ptE v A VABCx X2田田用因田用图<> Ť {}>!!!>

To display highest price we need to use MAX() with select command in sql. An average of the number…

Answered: QUESTION 1 Consider the following…

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

QUESTION 1

Consider the following database schema designed to store information about Books, and Chapters.

Book (BookID, BookTitle, Price)

BookChapter (ChapterID, BookID, ChapterTitle, NoPages)

Write the following queries in SQL.

1. Display BookTitle of the most expensive Book ( i.e. the Book with the highest Price).

2. For each BookID, display the average NoPages.

Consider the following database schema designed to store information about Books, and Chapters.
Book (BooklD, BookTitle, Price)
BookChapter (ChapterID, BooklD, ChapterTitle, NoPages)
Write the following queries in SQL.
1. Display BookTitle of the most expensive Book (i.e. the Book with the highest Price).
2. For each BooklD, display the average NoPages.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BI U S
Paragraph
Arial
10pt
E v A V
ABC
x X2
田田用因
田用图
<> Ť {}
>
!!!
>

Expert 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