Sql statement that displays the isbn-title and profit

Assignment Help Programming Languages

Reference no: EM13759561

Provide a SQL statement that displays the ISBN, TITLE and PROFIT for all books where the COST is

Problem #2

Provide a SQL statement that displays the ISBN, TITLE and PROFIT for all books where the COST is greater than or equal to $10.00 and less than or equal to $40.00. (The PROFIT is the difference between RETAIL and COST.) Include only those books that were published since January 1, 2001.

Problem #3

Provide a SQL statement that displays the TITLE and publisher NAME of each book in the "COMPUTER" CATEGORY.

Problem #4

Provide a SQL statement that displays the CUSTOMER# and LASTNAME for each customer along with the ORDER# of any order that the customer placed. The statement should include all customers including those that have not placed any orders.

Problem #5

Provide a SQL statement that displays the total QUANTITY of books ordered.

Problem #6

Provide a SQL statement that displays each SHIPSTATE along with the number of orders shipped to each state. Include only those states that more than 3 orders were shipped to.

Problem #7

Provide a SQL statement that displays the TITLE of all books that COST more than the average cost of all books.

Problem #8

Provide a SQL statement that displays the ORDER# for all orders that included the book titled "COOKING WITH MUSHROOMS".

Problem #9

Provide a SQL statement that displays each book CATEGORY in the database. The category should only appear once in the output.

Problem #10

Provide a SQL statement that displays the current date in the format MM/DD/YY.

Reference no: EM13759561

Questions Cloud

Bayes'' theorem and binominal distribution : Calculate the probability that a randomly selected car is new. Further, verify the results by comparing the conditional probability directly.

Discuss how validity and reliability will be achieved : Calculate the sample size using a 95% confidence level, and a 5% margin of error and Discuss how validity (and reliability) will be achieved.

Create brochure advertising your services as data repository : In this writing assignment, you will create a brochure advertising your services as a data repository. Research commercial data repositories

Assignment on subnetting : The calculations on how you get to the answers (50%). This is very important. If you don't provide the calculations or the way you get the answer, you will lose 50%.

Sql statement that displays the isbn-title and profit : Provide a SQL statement that displays the ISBN, TITLE and PROFIT for all books where the COST is greater than or equal to $10.00 and less than or equal to $40.00. (The PROFIT is the difference between RETAIL and COST.) Include only those books tha..

Make the companys vision come to fruition : What are the two or three biggest strengths the organization has that allow it to make the company's vision come to fruition?

Difference a database administrator and a database architect : Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles

What logical topologies are supported on an ethernet network : What logical topologies are supported on an Ethernet network and What is the purpose of the backoff on Ethernet networks

C program on unix that creates four new processes : Write and run a C program on UNIX that creates four new processes: A, B, C, and D. When the original process creates the new processes.

User Account

All Pages