Please write down the sql statements to answer the given

Assignment Help Database Management System

Reference no: EM13467239

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.

Reference no: EM13467239

Questions Cloud

Provide 2-3 specific examples that emphasize the need for : on the importance of academic integrity for students in the criminal justicesecurityadministration field. use at least

List and explain the advantages and disadvantages of : list and discuss the advantages and disadvantages of off-shoring

Cmpare this aspect of islamic art with art of another : in islamic culture there are certain religious restrictions on use of imagery and representation of human or animal

Explain the benefits of using hrm technology and compare : discuss the benefits of using hrm technology and compare and contrast the three types of hrm software mentioned in the

Please write down the sql statements to answer the given : please write sql statements to answer the following questions. your tables should still be on the oracle server. please

Conduct a needs analysis must include an organizational : write 450 words using your chosen organization - starbucks.conduct a needs analysis must include an organizational

What is the supreme courts justification for denying the : 1. what is the purpose of the initial interview? discuss at least five topics that might be covered by the officer in

Describe further why english claims that grown children : for most of us our families are very important. although they can cause discomfort anguish and pain they often infuse

Constitution and the articles of confederation discuss how : prepare a 2-3 page paper comparing three similar provisions in the u.s. constitution and the articles of confederation.

User Account

All Pages