Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task. Create a view named PLUME. It consists of the book code, title, type, and price for every book published by the publisher whose code is PL. a. Write and execute the CREATE VIEW command to create the PLUME view. b. Write and execute the command to retrieve the book code, title, and price for every book with a price of less than $13. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what are they? If not, why not?

4. This question continues from Q3. (a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty. (b) Can you insert the ZOOM table first? Provide a reason according to the relational database theory if it is not possible. (c) Write a Delete SQL to remove student ‘M M’ from the BB table. If it is not possible to remove the row, provide a reason according to the relational database theory. You must not use SID in the SQL because only the name is given. (d) Write an Update DML that will compute and update the duration in minutesin the Zoom table. Show the updated table and the DML.

I would like to create a function to sum up total order amount within the date range, but i don't know how to write the right query. The query below is for counting the total orders, but I want to change to sum up total order amount. The Database table is attached. Please assist. ************************************** USE SQLBook; DROP FUNCTION IF EXISTS GetDateRangewithordersAmountGO CREATE FUNCTION GetDateRangewithordersAmount(       @startDate DateTime,    @endDate DateTime)RETURNS TABLE ASRETURN (    select [State], count (*) as [TotalOrderAmount]   FROM [SQLBook].[dbo].[Orders]   WHERE [OrderDate] between @startDate AND @endDate   group by [State])GO SELECT * FROM GetDateRangewithordersAmount('2015-09-01','2015-10-31');GO

Write SQL statements to create at the two tables for the database. The tables must have at least three relevant columns with appropriate types, a primary key and at least one table should have a foreign key and the related foreign key constraints. CREATE TABLE students ( Student_id int NOT NULL PRIMARY KEY, Stud_firstname VARCHAR(30) NOT NULL, Stud_lastname VARCHAR(30) NOT NULL, Stud_email VARCHAR(80) NOT NULL UNIQUE advisor_id int, );   create table advisor ( advisor_id int not null primary key, stud_id int, adv_firstname varchar(30), adv_lastname varchar(30), foreign key(student_id) references students(student_id) );   [keep getting error, need help correcting]

Use the Pine Valley Furniture (PVF) database for this question. Write a SQL query to display the customer ID and total number of orders placed for those customers who placed more than one order.

use sql to answer the following question To perform below tasks, refer to tables in the JustLee Book database. Create a list that display the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. Which books were written by an author with the Last Name-First Name (BAKER JACK)? Perform the search using author’s last name/first name. Determine which book(s) purchased by customer Steve Schell. Perform the search using the customer name & last name, not the customer number. If he/she has purchased multiple copies of the same book, unduplicated(DISCTINC) the result.

PLZ HELP WITH THE FOLLOWING QUESTION  Using oralce sql or sql live Create a view named all_volunteer that gets details of all volunteers that assigned tasks in the organization. CREATE TABLE Packinglist(   List_ID INT NOT NULL,   Name VARCHAR(50),   Description VARCHAR(100),   PRIMARY KEY(List_ID)); CREATE TABLE Task(   Task_Code INT NOT NULL,   List_ID INT,   Task_Description VARCHAR(100),   Type VARCHAR(30),   Status VARCHAR(20),   PRIMARY KEY(Task_Code),   FOREIGN KEY(List_ID) REFERENCES Packinglist(List_ID)); CREATE TABLE Volunteer(   Vol_ID INT NOT NULL,   Name VARCHAR(50),   Telephone NUMBER,   Address VARCHAR(100),   PRIMARY KEY(Vol_ID)); CREATE TABLE Assignment(   Vol_ID INT,   Task_Code INT,   Start_Time TIME,   End_Time TIME,   PRIMARY KEY(Vol_ID, Task_Code),   FOREIGN KEY(Vol_ID) REFERENCES Volunteer(Vol_ID),   FOREIGN KEY(Task_Code) REFERENCES Task(Task_Code)); CREATE TABLE Package(   Pack_ID INT NOT NULL,   Task_Code INT,   Date DATE,   Weight FLOAT,   PRIMARY…