Answer question 9 only. I included the table Assignment 4: SQL for Data Retrieval (Single Table)Assignment 4 is based on the ABC Database's four tables we have created: CUSTOMER,ORDERTBL, PRODUCT and ORDERLINE.1. List the product (ProdID, Category and price) whose color is black and whose price fallsbetween 200 and 300.2. List the ID, category and description of the product that has the word 'jet' in itsdescription.3. List all customers whose name is 'Wally Jones' and lives in the state of Washington(WA).4. List all customers (last name, first name and zip code) whose zip code is missing(unknown).5. List the name and phone number of the customer with area code of '678’.6. We'd like to markdown by 10% the price of the product whose price is greater than orequal to 300. List the ID, category, price, and mark-downed price. Rename the mark-downed price as 'SalePrice'.7. List all color of the product for category B. Remove any duplicates.8. List the ID, category and size of the product whose size is 1, 2 or 3.9. List the ID, category, inventory value of the product whose inventory value is greaterthan 10,000. Inventory value can be calculated by multiplying price and quantity on hand.Name the inventory value as Inventory Value.10. List the ID and date of any orders that were placed in August, 2016. ESelectfrom product);100 %E ResultsMessagesProdiD Category DescriptionSize ColorPriceQuantityOnHand1A1Ahk Jet Printer 2White 100.00 100A2Ahk Jet Printer 3White 150.00 50B1BColor Printer1Beige 400.00 204B3BColor Printer2Beige 450.00 255B4BColor Printer3Black 300.00 506C1ALaser Printer5Black 250.00 367C2Laser Printer4White 450.00 45O Query executed successfully.23

From single or multiple tables, the SQL SELECT clause returns a result collection of records. A…

9. List the ID, category, inventory value of the product whose inventory value is greater than 10,000. Inventory value can be calculated by multiplying price and quantity on hand. Name the inventory value as InventoryValue.

9. List the ID, category, inventory value of the product whose inventory value is greater than 10,000. Inventory value can be calculated by multiplying price and quantity on hand. Name the inventory value as InventoryValue.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Define table adapter

A: Ans:- TableAdapters helps in providing communication between your application and a database. They…

Q: Select statement that will return all records and fields from a table

A: The question is asking for a SQL statement that will return all records and fields from a table in a…

Q: How do you save the results of an SQL query as a table?

A: Please find the answer below :

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: First query—selecting columns from table Display the query objects in the database. For each of the…

A: To run the given select query and discuss the result.

Q: What characteristics of an SQL statement makes it “structured”?

A: We are going to understand what makes SQL statements structured.

Q: SQL optimizer tries to convert queries with nested subqueries into a join operation for better…

A: Introduction to A SQL optimizer: A SQL optimizer is a program that modifies the structure of an SQL…

Q: w do I view tables in SQL?

A: Microsoft SQL Server gives a data pattern view as one of a few strategies for getting this metadata.…

Q: How do I view tables in SQL?

A: Let's see the answer:

Q: True or False Each column in a table must have a name.

A: Each column in a table must have a unique name. The entries within each column should match with…

Q: SQL code: to add an additional column ex: ALTER TABLE chicken ADD dish varchar(30) Question: How…

A: Alter table is used to add or modify table structure. In sql it is possible to add default values…

Q: How do I view tables in SQL?

A: In the given question SQL stand for structured query language.

Q: How do I view tables in SQL?

A: How do I view tables in SQL?

Q: The GROUP BY statement identifies the O Sort Fields None of these Filter All of these Table

A: Introduction : Given a MCQ , we have asked for the GROUP BY clause in SQL

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: Set the time it takes for data to arrive.

A: Define latency in data. When an event occurs, the amount of time it takes for your information to…

Q: Student(StudentID, age) School(SchoolID, city) Write an SQL statement for the following query: For…

A: The above question is solved in step 2:-

Q: introduction to databases Write PL/SQL code to create a function called best_ranked_post to list…

A: Create a function as mentioned above. Language SQL. Modifies SQL. Declare posts post function Set…

Q: I Wrote down QUESTION 7 as shown above. Not Question 1.

A: According to the information given:- As mentioned you need the solution of question 7 for that we…

Q: List out the rules for column naming convention.

A: We are going to understand the rules which must be used for column naming convention.

Q: When doing away with rows, columns, and tables, what should you remember most?

A: Introduction: A database is a collection of data organised for quick access, upkeep, and upgrading.…

Q: True or FalseString comparisons in SQL are case sensitive.

A: Explanation: The data in DBMS is stored and retrieved by using a specific language called SQL. DBMS…

Q: SQL has at least four benefits.

A: Explanation: TipThe acronym SQL stands for Structured Query Language. It's for storing data in a…

Q: SQL 10th Edition. Module 4 Lab Assessment 1 Task 1: Create the OWNER and PROPERTY tables.

A: To create the OWNER and PROPERTY tables with the specified fields, you can use the following SQL…

Q: How can you pick partial table contents?

A: Solution:- We can pick partial table contents by naming the desired fields and by placing…

Q: Name the rules exhange data between computers.

A: Given: Name the rules exhange data between computers.

Q: Explain the use of the SQL transaction control language (TCL) statements BEGIN TRANSACTION, COMMIT…

A: SQL Transaction Control Language: . SQL Transaction Control Language is allows statements for…

Q: QUESTION 2 BOOK NUMBOOK T IT 5235 Beginner's Guide to JAVA 5236Database in the Cloud 5237Mastering…

A: The question is a multipart type question based on SQL. Hence, according to the guidelines only…

Q: Create the table Students (sno, sname, dateofbirth, program, cgpa) Fees (sno, date, fee )…

A: NOTE- Since your question contain multiple sub-section . so we are providing solution to query…

Q: How do I view tables in SQL?

A: SQL stands for Structured Query Language and in this SQL, view is a virtual table which contains…

Q: In SQL, what statement do you use to retrieve specific rows from a table in a database?

A: SELECT: The "SELECT" statement is been used for selecting rows from a database. All the fields…

Q: Discuss when you should use tables and when using graphs.

A: Given when you should use tables and when using graphs.

Q: Write a SQL the imports in the year 2019. statement that will calculate the average value of all

A: The SQL query is given below with output screenshot

Q: Match each argument within a lookup function with its best description. Lookup value Table array…

A: LOOKUP function searches for a value from an array. The VLOOKUP function is a kind of lookup…

Q: sed for.

A: SQL Function: SQL function are some inbuilt function which helps to fetch data from the database.…

Q: When doing away with rows, columns, and tables, what should you remember most?

A: Given: Information that has been organised into a structure that makes it simple to access,…

Q: In SQL write a query to remove a table and it's schema from the database. Table: Player(PID, Name,…

A: For this we have to drop the table using the drop syntax. Here is the query:

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Enlist the totality of the data entry points.

A: Answer to the given question: Totality of the Data Entry Point: Data entry and data the board can…

Question

Answer question 9 only. I included the table

Assignment 4: SQL for Data Retrieval (Single Table)
Assignment 4 is based on the ABC Database's four tables we have created: CUSTOMER,
ORDERTBL, PRODUCT and ORDERLINE.
1. List the product (ProdID, Category and price) whose color is black and whose price falls
between 200 and 300.
2. List the ID, category and description of the product that has the word 'jet' in its
description.
3. List all customers whose name is 'Wally Jones' and lives in the state of Washington
(WA).
4. List all customers (last name, first name and zip code) whose zip code is missing
(unknown).
5. List the name and phone number of the customer with area code of '678’.
6. We'd like to markdown by 10% the price of the product whose price is greater than or
equal to 300. List the ID, category, price, and mark-downed price. Rename the mark-
downed price as 'SalePrice'.
7. List all color of the product for category B. Remove any duplicates.
8. List the ID, category and size of the product whose size is 1, 2 or 3.
9. List the ID, category, inventory value of the product whose inventory value is greater
than 10,000. Inventory value can be calculated by multiplying price and quantity on hand.
Name the inventory value as Inventory Value.
10. List the ID and date of any orders that were placed in August, 2016.

ESelect
from product);
100 %
E Results
Messages
ProdiD Category Description
Size Color
Price
QuantityOnHand
1
A1
A
hk Jet Printer 2
White 100.00 100
A2
A
hk Jet Printer 3
White 150.00 50
B1
B
Color Printer
1
Beige 400.00 20
4
B3
B
Color Printer
2
Beige 450.00 25
5
B4
B
Color Printer
3
Black 300.00 50
6
C1
A
Laser Printer
5
Black 250.00 36
7
C2
Laser Printer
4
White 450.00 45
O Query executed successfully.
23

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2 Answer to question 9

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

change month number to month name in dataframe in pandas
Write the required SQL statements to create the PET_2 table
Briefly explain the difference between a nested if statement and a lookup function using a lookup table. Why is using a lookup function and table more efficient and effective? Provide an example.
What is the purpose of keywords in SQL (Structured Query Language) when writing database queries?
One thing to keep in mind when you remove data from tables, rows, and columns is
In a database, Write SQL query to show table structure of table name Guardians.
order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date
What method of Statement is used if you want to execute DELETE SQL statement?
What are the dimensions (#rows x #columns) of this table? CC --> CC Select one: a. 1*2 b. 2*2 c. 2*1 d. Error
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Please Type! what is an Isolation property of transactions in SQL (database)
Using php and sql: create a query that will output only the user_id and message for user_id 8