Question: Fundamentals DataBase Course. 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,

Fundamentals DataBase Course. 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).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!