Question: Given the following schema, write the SQL statements for the following queries. Query 1) Show me the book names and their respective quantities for open

Given the following schema, write the SQL statements for the following queries.

Given the following schema, write the SQL statements for the following queries.

Query 1) Show me the book names and their respective quantities for open orders (the orders which have not been shipped) at midnight 10/13/14.

Query 2) Show the names of customers who have ordered multiple (more than 1) books and the corresponding quantities. List the result in the descending quantity.

Query 3) Show the names of customers who have ordered multiple (more than 1) books and their respective telephone numbers.

Suppliers (SupplierID, Company Name, Cont actLastName, ContactFirstName, Phone) Books (BookID. Title, nit-Price, Author, Unit-in-Stock, Supplier!D. . SubjectID) Subjects (SubjectID. CategoryName) OrderDetails (BookID. OrderID. Quantity) * * * Orders (OrderID, CustomerID. EmployeeID, OrderDate, ShippedDate, ShipperID) . Employees (EmploveeID, LastName, FirstName) * Shippers (ShipperID.ShpperName)

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!

Given the following schema, write the SQL statements for the following queries. Query 1) Show the unique names of all the books John Smith and Jackie Collins ordered. Query 2) Show the names of all...

Given the following schema, write the SQL statements for the following queries. Query 1) Show the name of the customer who has ordered at least one book written by Thomas. Query 2) Show the name of...

Given the following schema, write the SQL statements for the following queries. Query 1) Show the names of all the books shipped on 09/10/14 and their shippers. Query 2) Show the names of all the...

Given the following schema, write the SQL statements for the following queries. Query 1) Show the titles of all the books which have more than 5 units in stock. Query 2) Show the total price John...

Given the following schema, write the SQL statements for the following queries. Query 1)Show the names of the CUSTOMER(S) who ordered AT LEAST ONE BOOK whose name includes Louisiana. Query 2)Show the...

This is the bookstore.sql: DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

CREATE TABLE donor ( donor_id SERIAL PRIMARY KEY, donor_name VARCHAR(500) NOT NULL, donor_email VARCHAR(200) NOT NULL, donor_address VARCHAR(200) NOT NULL, donor_city VARCHAR(100) NOT NULL,...

For how to: https://www.freecodecamp.org/news/how-to-install-mysql-workbench-on-windows/ Take a screen shots of your installation and paste here Watch this tutorial Section on how to use MYSQL work...

Tran Lee plans to set aside $3,500 a year for the next eight years, earning 5 percent. What would be the future value of this savings amount? Use Exhibit 1-B. (Round your discount factor to 3 decimal...

4. Let's say you get a S8000 inheritance, and you wisely decide to put it into a long-term investment that pays 7% in simple interest each year. How much interest will you earn at the end of five...

Question 5 ( 3 points ) You want to buy a new equipment to replace an existing one. The new equipment will be depreciated down to zero using straight - line depreciation over its 1 0 - year life. The...

what is one thing mcdonals marketing globally that they have to work on

13-8 Why is it so important to understand how a business process works when trying to develop a new information system?

13-7 Some have said that the best way to reduce systems development costs is to use MyLab MIS MyLab MIS application software packages, SaaS, or userfriendly tools. Do you agree? Why or why not?

13-6 Why is selecting a systems development approach an important business decision? Who should participate in the selection process?