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

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 unique names of all the books John Smith and Jackie Collins ordered.

Query 2) Show the names of all the ordered books and their total quantities. List the result in the ascending quantity.

Query 3) Show the names of the customers who ordered at least a book whose name includes Louisiana.

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

Using the PSQL function in a linux terminal solve. PART2 Provide solutions with screenshots please show everything. I will like pls solve Heres a txt file that you can use for test...

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

Please help me with this assignment In this project you will build a database for a public library. This database is aimed to collect and analyze information about the clients' reading interests. The...

Automatic data processing, inc. (adp), handles payroll and tax filing processing for more than 300,000 customers. in other words, firms outsource these functions to adp. suggest possible segmentation...

A person wants to take a bath, and fills the tub with 50 L of water at a temperature of 38o C after receiving a phone cell. The bath water had cooled by10 o C. How much more hot water at 80 o C must...

True or False? A radio clock shows a schedule of the hourly programming. True FalseTrue or False? A radio clock shows a schedule of the hourly programming. True False

Bank Reconciliation 1. The cash balance per books for Bakken Company on September 30. 200s is $10,740.93. The following checks and receipts were recorded for the month of October, 2005 Checks...

=+3 What do you predict for the future of unions and union relations in the global economy? Why?

=+terms of the different types of international employees that MNEs can draw

=+j Explain the many options available to MNEs for staffing their operations in