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

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

One thing to keep in mind when you remove data from tables, rows, and columns is
order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date
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
You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.
How can we check if a table has minimum redundency?A) There is no way to checkB) See if a table has any primary values duplicated somewhere elseC) Use a normal form to checkD) See if a table has a lot of null values
Looking Up Data- INDEX () & MATCH() Which of the following statements describes how the INDEX) and MATCH() functions are combined to lookup data? A) MATCH() is used within the INDEX() function to return the relative position of the data in the lookup table B) INDEX) is used within the MATCH() function to return the relative position of the data in the lookup table C) MATCH() is used to match values from the lookup table and the source table, INDEX() returns the index of these values D) INDEX calculates the relative position of the data in the source table and returns values for MATCH() to lookup
Database sql 1-Write the syntax to create an object table called people using people_type
When deleting rows, columns, and tables, what is the most important thing to remember?