Question: Create the following queries using Data Manipulation Language (DML) student must be able to explain the queries: Find the total number of feedback per book.

able to explain the queries: Find the total number of feedback per book. Show book id, book title, and total number of feedback per book. Find the total number of feedback per member. Show member id, member name, and total number of feedback per member. Find the total Create the following queries using Data Manipulation Language (DML) student must be able to explain the queries:

number of book published by each publisher. Show publisher id, publisher name,

Find the total number of feedback per book. Show book id, book title, and total number of feedback per book.

Find the total number of feedback per member. Show member id, member name, and total number of feedback per member.

Find the total number of book published by each publisher. Show publisher id, publisher name, and number of book published.

Find the total number of book for each category. Show category id, category name, and number of book for each category.

From the book table, list the books where quantity is more than the average quantity of all books.

Find the total number of books ordered by store manager from various publishers.

1 Member_ID Book_ID Book_ID Book_title FeedBack_score Book_Rating MBR001 BK002 wonder 9 very good MBR002 BK002 wonder 10 masterpiece MBR003 BK005 Shadows 5 not bad MBR004 BK006 Let it rain 2 bad MBR005 BK005 Shadows 8 MBR006 BK006 Let it rain 9 very good 5 4 5 good 6 1 2 Pub_ID PU001 PU002 PU003 PU004 PU005 Pub_Name Pub_Email Reem Reem.AL@gmail.com Malak Malak.fi@gmail.com Hisham Hisham.al@yahoo.com Ebrahim Ebrahim@yahoo.com Arwa Arwa.ah@gmail.com Mohamed Mohamed.ah@gmail.com Pub_Address jalan midah 8A.prisma cheras Bukit jalil,endah ria jalan ampang.indah Jalan Cheras Jalan Midah 3 4 5 PU006 Jalan taman Book_ID BK001 Pub_ID PU001 1 2 BK002 PU002 Book_title Girl on the train wonder Alex and elenour Falut in our stars Shadows 3 Book_Quantity Book_Author Book_Category Book_Price Book_Date 300 john Drama 40.8 2011-05-05 239 alex Comdey 69.34 2012-04-06 380 Noor Romantic 58.78 2013-06-08 390 Nabil Romantic 45.9 2014-05-25 250 Esra Horror 30.9 2014-01-27 400 Reemon Romantic 50.9 2013-05-22 BK003 BK004 PU003 4 PU004 BK005 PU005 5 6 BK006 Let it rain PU006 1 Member_ID MBR001 MBR002 MBR003 2 3 Member_Name Member_Gender Member_Address Member_Contact Member_Email Customer_ID Aisha Female jalan kajang. putri 1136809 Aisha.ft@gmail.com CUS001 Reem Female jalan tun razak.perdana 11370456 Reem.jk@gmail.com CUS002 Hamoud Male jalan bukit jalil, endah 1124578 Hamoud.yu@gmail.com CUS003 Tarea Male serdang.one south 11567903 Tareq.op@gmail.com CUS004 Layla Female Kajang,seri putra 11456797 Lulu.kl@yahoo.com CUS005 Yara Female Kajang,seri putra 113645673 Yara.kl@yahoo.com CUS006 4 5 6 MBR004 MBR005 MBR006 1 2 3 Manager_ID Manager_Name Manager_Email Manager_Address EM001 Luay Luay.ty@gmail.com bukit bintang bulan EM002 Noor Noor.ahmed@gmail.com Bukit jalil.oug EM003 Tayba Tayba.ah@gmail.com Damansara,ria EM004 Yusra Yusra.hg@yahoo.com Montikyara EM005 Nageed Nageeb.iu@yahoo.com Juta mines EM006 Layla Layla.iu@yahoo.com Parkhill 4 5 6 b) Create the following queries using Data Manipulation Language (DML) - student must be able to explain the queries. i. Find the total number of feedback per book. Show book id, book title, and total number of feedback per book. ii. Find the total number of feedback per member. Show member id, member name, and total number of feedback per member. iii. Find the total number of book published by each publisher. Show publisher id, publisher name, and number of book published. iv. Find the total number of book for each category. Show category id, category name, and number of book for each category. V. From the book table, list the books where quantity is more than the average quantity of all books. vi. Find the total number of books ordered by store manager from various publishers

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!

B- Create the following queries using Data Manipulation Language (DML) student must be able to explain the queries. i- Find the total number of feedback per book. Show book id, book title, and total...

A bookstore located in Kuala Lumpur Malaysia has vast collection of books in its warehouse. The bookstore ordered books of various genres from different publishers and sell them to the customers. As...

Create the following queries using Data Manipulation Language (DML) - Each student must be able to explain the queries and justify the approach taken. Student 1 1. List the details of nurses...

How to create the following queries using Data Manipulation Language (DML). Thanks Student 1 1. For each member who has borrowed more than 2 books, list the member names and the total number of books...

This assignment aims to develop a broad knowledge of storing and managing data to satisfy the organizational requirements. These will be reinforced by developing the practical skills required for...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Econ 2123. Introduction to Econometrics Sections 80/83. Prof. Williams Homework 8 due Thursday April 9 You can work together with other students in the class to answer each of the following problems...

This case study is two parts - as shown & marked in the table- I have completed part one, the other attachment. However, i need help with part two - Scemarav smpliverinent at the MrS Moywat. at the...

Calculating by using queries 21? Updating records by using queries As you use a database and as it grows, you might discover that errors creep in or that some information becomes out of date. You can...

The following selected transactions were completed during June between Shapiro Company and Bacarti Company: June 8. Shapiro Company sold merchandise on account to Bacarti Company, $24,000, terms FOB...

We are living in a world of controversy. Every day a new topic emerges that shapes our legal system and our democracy. The functions of law are described as intending to simultaneously: (1) keep the...

The Employment Retirement Income Security Act Blank _ _ _ _ _ _ . Multiple choice question. requires employers to establish a pension plan regulates the management and vesting of established pension...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. What new skills will trainers need to be successful in the future?

3. What is rapid instructional design? How does it differ from the traditional training design process discussed in Chapter 1? (See Figure 1.1.)

4. How does the use of a learning management system better link training to business strategy and goals?