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

Similar questions

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?
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
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
A Pivot Table is the column name with its table name. O True O False
Could you do typing the query here please?
How do we join multiple tables in a SELECT statement? Give an example.
7. List the shipping city and state for the order that had the longest shipping delay. SQL commands