I need question 6 answered. I've included the table needed 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 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.

Answer of the given question number 6 is:

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

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

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: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: In order to prevent the duplicate values to be inserted to a column of a table, we use the DISTINCT…

A: In order to prevent the duplicate values to be inserted to a column of a table, we use the UNIQUE…

Q: Describe two different situations where it would make sense for a column in a table to…

A: Auto increment for a column in a table First scenario is movie tickets or bus tickets When you…

Q: The team wants to track potential list of users who may have forgotten their items on the cars.…

A: SELECT U.USER_FIRST_NAME, U.USER_LAST_NAME, T.TRAVEL_START_TIME, T.TRAVEL_END_TIME FROM USERS U…

Q: What does it mean to say that the select statements for two tables are union compatible? Question…

A: Relational algebra operators: The relational algebra operators that can be applied to a pair of…

Q: If multiple tables are joined together, you can select columns from specific tables by specifying…

A: In SQL, you can apply Join on multiple tables . Join is basically joining two or more tables using a…

Q: What is the condition for any table to be in first normal form.

A: A relation/table is said to be in First Normal form(1NF) if it does not contain any multivalued…

Q: When is it not a good idea to establish an index for a table?

A: Please refer to the following step for the complete solution of the problem above.

Q: As you start to get rid of sections, rows, and tables, keep the following in mind:

A: When working with documents or datasets, it is common to delete sections, rows, or tables of…

Q: it is possible to use a NATURAL join, there are some downsides to using this type of join. What are…

A: Joins: Joins in sql commands which are used to combine rows from two or more tables. based on a…

Q: Write a SELECT statement that joins the Instructors and Courses tables and returns these columns:…

A: To accomplish this task, you can use a SQL SELECT statement that performs a LEFT JOIN between the…

Q: what is the necessary field in order table in access

A: Tables are the underpinning of an Access data set. Access stores information in tables. This example…

Q: What is the difference between an INNER JOIN and a LEFT JOIN? a. an INNER JOIN is an obsolete form…

A: In the realm of relational databases and SQL, the use of JOIN operations is pivotal for combining…

Q: There are ten columns in the table "customer," yet there is no row. A total of 10 new rows are added…

A: TipA table is a list of connected data kept in a database in table format. A table in relational and…

Q: Provide the syntax to change the name of a table?

A: In the SQL table is used to store the data in a well-organized manner. The table is also known as a…

Q: What is the result of the query below? SELECT * FROM table1 WHERE val1 IN (SELECT vall FROM table1…

A: A SQL query is a high level English sentence used to work with a database which could be the…

Q: Question 15 Suppose that you have the following table created as: CREATE TABLE TAB1 (NAME VARCHAR2…

A: For this question we can decompose the name by using parsename. Parsename will decompose a full name…

Q: What are some of the different ways to join tables in a SELECT?

A: We have inner join, left join, right join, full join, self join, and using select command we will…

Q: The StayWell marketing team wants to send mail to all residents. You need to return the first name…

A: Explanation:

Q: Create a set of lookup tables

A: In computer science, a lookup table (LUT) is an array that substitutes a simpler array indexing…

Q: I need help with the select statement that returns the output below using a outer join with table…

A: In SQL, an outer join is a type of join operation that combines rows from two tables, even if there…

Q: In your essay, please discuss the benefits and drawbacks of not using the skip list.

A: A skip list is a probabilistic data structure. Answer: Advantages of bypassing the skip list: The…

Q: Does a firewall pose a threat to VoIP calls in the same way that it does to streaming audio?

A: As VoIP (Voice over Internet Protocol) communication becomes more prevalent, it is important to…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Are the tables normalized? I'd like to know how to normalize the tables in this question

A: Yes, the tables are normalized here. Normalization is the process of creating the most efficient…

Q: What does the table adapter have to do with the data source?

A: The table adapter is a component in a software application that serves as a bridge between a data…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: Find the constraint name that references a column of a table and it can be the same table also. O a…

Q: What's the easiest way to retrieve all the rows of a table with a query?

A: 1) If we have table and we want to retrieve all rows of data, we can use we can use the wild card *…

Q: Mr. Rohan has constructed a table called'student,' which contains information such as the student's…

A: Tip A primary column (or a set of columns) is used to uniquely identify rows in a table and database…

Q: What’s the basic difference between the ROLLUP and CUBE extensions of the GROUP BY clause?

A: The GROUP BY clause is used to group aggregate function outcomes according to a given column. The…

Q: Create a derived table which computes row number for employees in the USA partitioned by the…

A: Here, I have to write a solution for the above question.

Q: You are designing a table for the Sales department. You need to include a column that contains each…

A: 1) You are designing a table for sales department, and you need to add column that contains sales…

Q: Briefly explain the difference between a nested if statement and a lookup function using a lookup…

A: Given: Briefly explain the difference between a nested if statement and a lookup function using a…

Q: Hello, I am working on the stored procedure. However, I am stuck a little and cannot figure out how…

A: Hi, I analysed the code already written and can find some issues there. 1) The below statement…

Q: The 'customer' table contains ten columns but no row. The table is then updated with 10 new rows and…

A: Start: The term "table" refers to a collection of connected data that is recorded in a database in a…

Q: The 'customer' table contains ten columns but no rows. The table is then updated with 10 new rows…

A: Degree of a table in SQL: The number of attributes or columns in a relation is referred to as the…

Q: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit…

A: Here, the new record has to be added to a table and this process is called as Insertion and the…

Q: Customers table customerid firstname lastname 10101 10298 10339 10357 10409 10410 10429 10415 10428…

A: The given SQL commands create a table named Customers with five columns, namely customerid,…

Q: Surpreeth would want to add two additional customer entries to the customer table. Which command is…

A: We are given a situation in a database table where we are going to apply sql command to add new…

Question

I need question 6 answered. I've included the table needed

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

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.

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

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

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Create a SQL statement to Add a CHECK constraint for the CTYPE column in the CLIENTS table. It must accept either New or Old only.
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.
when we want to change the data type in a table, how do we do that?
Order of tuples in a table is irrelevant, true or false?
What did you take away from the process of creating your religion characteristics table?
Under what circumstances should you not create an index for a table?
Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number 8 PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number Bedroom Number 5 Room Status Varchar2 10 REFERENCES to CID in Clients Table CID Number
What exactly is the issue with altering the name of a table?
a. Write the SQL commands to create each table after normalization.b. Write insert command to add 5 rows in each of the table.c. Write a delete command to delete row from each table.d. Write the commands to query following values.1. Show Product id and finish date for all Products2. Show Product id and finish for all Products, sort by Product_Line_ID byascending order3. Show Product id and finish for all Products, sort by Product_Line_ID bydescending order4. Show each Product_Line_ID and the total number of Products for theProduct_Line_ID
Scenario and Database Model: Instant Ride InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the Instant Ride mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: USER_ID 3001 3002 3003 3004 3005 3006 3007 3008 USERS Table 2001 2002 2003 2004 USER_FIRST_NAME Willie Justin Anthony Ece Jack Ryan Nursin Sarah Bobby Randy Jose DRIVERS Table Nursin Butler Howard In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: Walker DRIVER_ID DRIVER_FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE_ID…
what is table ?