Question: Create SQL queries on your database based on the following requirements: 1. Determine the Total Sales to each customer and profit generated from each customer.

Create SQL queries on your database based on the following requirements:

1. Determine the Total Sales to each customer and profit generated from each customer. List CustID, LastName, FirstName, TotalSales and TotalProfit.

2. Display ISBN and Title of each book written by multiple authors.

3. Determine ShipCity and ShipState with Highest total Sales [SUM(QUANTITY*Retail)]. Display ShipCity, ShipState and Total Sales.

4. Display Last Name & First Name of Authors who has the same last name of a Customer.

5. What is the retail price of the least expensive Cooking book? Display ISBN, Title and Retail price of the book.

Create SQL queries on your database based on the following requirements: 1.

ERD of JustLeeBooksDatabase Orders BOOKAUTHOR 8 CustiD 8 OrderlD ISBN 8 AuthorlD CustD State Author ShipState AuthorlD ORDERITEMS Order D Fname ISBN promotion Books ISBN PubDate PubiD Cost PublD Contact Phone Category

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!

Can you please help me come up with the codes to make a query for number 1-6? Assignment 5-SQL Queries Create SQL queries on JustLeeBooks Database based on the following requirements 1. Determine the...

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

I am having trouble with a portion of this project and wanted to make sure my SQL is correct. I attempted to copy my ER Diagram (would not let me paste screen shot) but have copied the project...

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

Hi. I'm asked to take this class for graduation but I don't know how to do any of this. Please help me! I'm already devastated with the whole concept and Finance is new to me. Idk what I'm doing in...

1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job per customer. The...

Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job...

You are a small business consultant, and your client will be starting a Beekeeping Store, which will provide all the materials needed for beekeepers (apiarists) as well as provide consulting advice...

Steward pic commences business on 1 January year 1. Let us assume all transactions are by cheque and no credit is given nor taken and that Steward deals only in one type of item of inventory. 1...

What is the risk premium for a company that has a yield rate of 7 . 5 0 % when the risk - free rate is 6 . 5 0 % ? 1 . 9 0 % 1 . 2 0 % 1 . 0 0 % 1 . 9 0 %

Exercise 8.7 (Algo) Costing Inventory in a Periodic System (LO 8-4) Rogers Products uses a periodic inventory system. The company's records show the beginning inventory of PH4 oil filers on January 1...

How might course design effectively accommodate employees with autism?

What is the relationship between diversity, inclusion, and equity?

How does a rapidly changing business environment influence training outsourcing? Explain.