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

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 name of the customer who has ordered at least one book written by Thomas.

Query 2) Show the name of the customer who has ordered at least a Fiction book or a Travel book and the book names.

Query 3) Show the name of each category and the cheapest price of the books in that category.

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 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 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 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 names of the CUSTOMER(S) who ordered AT LEAST ONE BOOK whose name includes Louisiana. Query 2)Show the...

I need help creating the following queries in MYSQL 2. In this problem, you will design a relational schema for an online food delivery system similar to DoorDash. This service allows people to order...

For the bookstore database, write expressions of relational algebra to answer the following queries: 1.) Customers (name) who ordered at least one book that customer #1111 ordered. 2.) Customers...

It's urgent ! , I need its answer now please. III . SQL and relational algebra ( 3 points for each , total 18 points ) CUSTOMER ( CustID , name , address , zip , phone , isContractor ) CSZ ( zip ,...

CUSTOMER(custID, name, address, zip, phone, isContractor) CSZ(zip, city, state) INVOICE(invID , custID, dateOfInv, finalTotalBill, amountDue, creditCardNo) ITEMTYPES(typeID, description,...

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

Deb Bishop Health and Beauty Products has developed a new shampoo, and you need to develop its aggregate schedule. The cost accounting department has supplied you the costs relevant to the aggregate...

The Efland Company leases equipment to Orange Company. Efland pays $3,000 initial direct costs in negotiating the lease. Required 1. Explain what initial direct costs are. 2. Indicate precisely how...

Si el importe de impagados asciende a 500.000 euros y la cuanta de las ventas brutas es de 6 millones de euros, Seleccione una: a. El ndice de impago de 8% ha de ser evaluado y establecer un plan de...

Chapter 21 Excel Homework Problem (2 af 2) Due Date: September 25, 2020 by 11:59 pm (upload to Learn) The comparative balance sheets for 2020 and 2021 are given below for Lynbroak, Inc. The Statement...

3. Should participants be incentivized to attend? If so, how would you suggest?

1. Using Allisons (1971) model, what lens(es) do you believe Chief Jackson used to make these decisions?

2. How much time should be allocated to the focus group?