Consider the following database schema:
Books (ISBN, title, genre, price, edition, authorID, branchID)) Authors (id, name, genre) Branch (id, name, address) Member (id, name, address, department) Borrower (MemberID, ISBN, issueDate, dueDate, returnDate)
Answer the following questions using Subquery:
a) Find out the name of the book with the minimum price from the 'Fiction' genre. b) Find out the branch details having the book titled 'Wings of fire". c) Find the name of all the borrowers. d) Find out the ID of the members who have not borrowed any books yet. e) Find the IDs of the branches that contain more than 250 hooks.
Answers
Answer:Question: 1. Consider The Following Database Schema: Books (ISBN, Title, Genre, Price, Edition, AuthorID, Branch) Authors Dd, Name, Genre) Branch (D, Name, Address) Member Id, Name, Address, Department) Borrower (MemberID, ISBN, Issue Date, DueDate, ReturnDate) Now, Provide SQL Queries Corresponding To The Following Questions: A) Find Out The Price Of The Book Titled
This problem has been solved!
See the answer
1. Consider the following database schema:
Books (ISBN, title, genre, price, edition, authorID, branch)
Authors dd, name, gen
Id:2019777777710
And others you can add any value,as your wish
Show transcribed image text
Expert Answer
a) Select price From Books title='Wings of fire'; b) Select Authors.* From Bo…
View the full answer
Transcribed image text: 1. Consider the following database schema: Books (ISBN, title, genre, price, edition, authorID, branch) Authors dd, name, genre) Branch (d, name, address) Member id, name, address, department) Borrower (MemberID, ISBN, issue Date, dueDate, returnDate) Now, provide SQL queries corresponding to the following questions: a) Find out the price of the book titled "Wings of fire'. b) Find out the author details of the book titled "Wings of fire'. Find out how many books there are of each genre. .) Find out the name of the authors who have written books of both Fiction and Thriller genres. e) Find the genres of the books with average price less than 100 Taka
Explanation:
find out the name of the book with the minimum