Question
Using the following relations to write SQL statement that follows: Author ( Author_ID, FIRST_NAME, LAST_NAME) Book_authors_books ( ISBN, Author_ID) Book_descriptions ( ISBN, Title, Price, Publisher,
Using the following relations to write SQL statement that follows:
Author (Author_ID, FIRST_NAME, LAST_NAME)
Book_authors_books (ISBN, Author_ID)
Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages)
1- Retrieve all the books that cost less than 35.
2- Retrieve all the authors in alphabetical order(A-Z).
3- Retrieve all the possible information about the most expensive book that published by "New Math" publisher (the data should include authors).
4- Increase price value by 10% of all books that published in 2015 (use update).
Please the answer should typing, not scanning or photos
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started