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

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 titles of all the books which have more than 5 units in stock.

Query 2) Show the total price John Smith has paid for the books.

Query 3) Show me the name of the customer who has paid less than $20 in totals.

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

sql queries for oracle database. b) (8 points) Write the database schema for this ER diagram. c) (8 points) Write the CREATE TABLE statements for all tables identified for this database. The create...

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

Because the manufacturers major objective in instituting a training program for channel member salespeople is to get them to give preferential treatment to the firms products, the manufacturer should...

Prepare a cash budget for the period 1 November and 31 December 2018. The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is...

Income Statement Income Gross sales 5750000 Sales returns and allowances 200000 Net sales 5550000 Cost of goods sold 2300000 Gross profit 32 Dividends received from stock investments in lessthan20...

Record adjusting journal entries for each separate case below for year ended December 3 1 . Assume no other adjusting entries are made during the year. a . Unearned Rent Revenue. The Krug Company...

LO1 Understand human resource management and define human capital.

2. Systematically select workers so that they fit the job, and train them effectively

4. Support workers by carefully planning their work and smoothing the way as they do their jobs.