Consider the following database schema designed to store information about Books, and Chapters. Book (BooklD, BookTitle, Price) BookChapter (ChapterlD, BooklD, ChapterTitle, NoPages) Write the...


Consider the following database schema designed to store information about Books, and Chapters.<br>Book (BooklD, BookTitle, Price)<br>BookChapter (ChapterlD, BooklD, ChapterTitle, NoPages)<br>Write the following queries in SQL.<br>1. Display BooklD of all books with price less than the average price of all books.<br>2. Display ChapterlD, BooklD, ChapterTitle of all chapters that include the word 'Database' in the ChapterTitle.<br>

Extracted text: Consider the following database schema designed to store information about Books, and Chapters. Book (BooklD, BookTitle, Price) BookChapter (ChapterlD, BooklD, ChapterTitle, NoPages) Write the following queries in SQL. 1. Display BooklD of all books with price less than the average price of all books. 2. Display ChapterlD, BooklD, ChapterTitle of all chapters that include the word 'Database' in the ChapterTitle.

Jun 06, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?