Course Solutions Uncategorized (Solved) : Given Following Schema Write Sql Statements Following Queries Query 1 Show Names Customer Q29098235 . . . .

(Solved) : Given Following Schema Write Sql Statements Following Queries Query 1 Show Names Customer Q29098235 . . . .

June 27, 2024June 27, 2024| adminadmin| 0 Comment| 8:09 pm
Categories:

 

Given the following schema, write the SQL statements for thefollowing queries.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)

Query 1)Show the names of the CUSTOMER(S) who ordered AT LEASTONE BOOK whose name includes “Louisiana”.

Query 2)Show the name of the CUSTOMER(S) who has ordered ATLEAST ONE “Fiction” BOOK or AT LEAST ONE “Travel” BOOK and the BOOKNAMES.

Expert Answer

An answer will

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Answered):Math Help 42 . . . .(Answered):Math Help 42 . . . .

<h3>Question Description</h3> <p style="margin-bottom:.5em;border-width:0px;font-family:Helvetica, Arial, sans-serif;font-size:13px;font-style:normal;font-variant:normal;line-height:16.899999618530273px;background-color:rgb(255,255,255);"/><p>Image text transcribed for accessibility: Which of the following statements are true for all propositions p and q? (True/False)If p q, then p is true or

Read MoreRead More