** text only + not copied from another answer online plz+ the subject is fundame

ID: 3712824 • Letter: #

Question

** text only + not copied from another answer online plz+ the subject is fundamental of database**

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).

1. SELECT Title FROM Book_descriptions WHERE Price < 35;

2. SELECT FIRST_NAME, LAST_NAME FROM Author ORDER BY FIRST_NAME;

3. SELECT MAX(Price) FROM Book_descriptions WHERE Publisher = "New Math";

4. UPDATE Book_descriptions SET Price = Price * 1.35
WHERE Pub_date = 2015;

**Comment for any further queries.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.