Question: 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

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 the names of all the books shipped on 09/10/14 and their shippers.

Query 2) Show the names of all the books John Steely was responsible for.

Query 3) Show the total price each customer paid and their names. List the result in the descending price.

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 me the book names and their respective quantities for open orders (the orders which have not been...

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 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...

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

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,...

Assume Harry dies at age 75 and his assets include a RRIF with a market value of $270,000. What strategy would result in the LARGEST tax liability to Megan following his death? What strategy would...

Thomas Holme, a mid-level product manager for Dorothys Shoes, thinks his company should switch from LIFO to FIFO. He says, My bonus is based on net income. If we switch it will increase net income...

Suppose that the mean and the standard deviation of annual returns of financial assets are 1 0 % and 8 % . Assume that the financial assets are statistically independent of each other. If you invest...

The taxpayer, Tom Bradshaw, provides you with the following information: Tom and Katie divorced in 2014. Under the divorce decree, Tom is required to pay alimony of $3,000 per month and child support...

What are the characteristics of effective onboarding programs? How can virtual onboarding still include those characteristics?

What are the implications of reasonable accommodation when training employees with disabilities? Employees with religious beliefs?

Watch the video on diversity and inclusion at DuPont at www.youtube.com/watch?v=uHYuDDHvU64. Review www.dupont.com/careers/diversity-and-inclusion.html. Why does DuPont foster diversity and...