Details of this Paper

writing and connected to Oracle Server




Wentworth Institute of Technology;Comp355 Database Management Systems;Spring 2014;Lab 6;Using the set of books tables that you created in Lab 5, please write SQL statements to answer the following questions. Your tables should still be on the Oracle server. Please hand-in both the query as well as the output for each problem.;1. List all branches with less than 100 employees.;2. List all publishers in Massachusetts.;3. List the total number of publishers in Massachusetts.;4. List the book title and price of all books that are not in the inventory of branch 2.;5. List the total number of books that are paperback and cost less than $25.;6. List all books written by author_number 33;7. List the total number of books with more than 1 author.


Paper#69460 | Written in 18-Jul-2015

Price : $27