Question

Please use SQL to answer queries.

Answer 1

Answer:

Please find the attachment of query:

Explanation:

IIn the given query multiple select clauses and where the condition is used which can be defined as follows:

In this query first, we select the "Dept" column from the "COURSE" table, and in where clause it uses another select clause in this clause it selects the "Course#" column from the "BOOK_ADOPTION" table.  

Inside this, another condition is used, that selects "Book_isbn" from the "TEXT" table and in where clause, it matches the publisher value that is "Addison-Wesley".