Answer question 9. Please use select from and where. Here's 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

Answered: er question 9. Please use select from…

Engineering

Computer Science

er question 9. Please use select from and where. Here's the table

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: Using the Bowlers and Bowler_Scores tables, list the BowlerID, bowler name, and raw score for each…

A: The given problem requires us to find the BowlerID, bowler name, and raw score for each bowler who…

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: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database, SELECT statement are used. The data is saved in a result table…

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: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

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: When naming a table what prefix would you use?

A: Database by using the prefix A database prefix basically is been used to mention connectivity for a…

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: Note: I am asking you to create a table in a database. If you already have a database, that's fine,…

A: The objective of the question is to create a SQL table with specific data types and constraints. The…

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B Becomes the last column in the table

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: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Note: I am asking you to create a table in a database. If you already have a database, that's fine,…

A: The objective of the question is to create a SQL table with specific columns, data types, and…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Create a student table. The student table needs to include the following columns: Student ID Student…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Determine which types of books are currently available in the current inventory. Each category…

A: Real-world examples can make inventory models easier to understand. The following examples…

Question

Answer question 9. Please use select from and where. Here's 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.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

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

question 11 please use the picture below to answer the following question Write a SQL statement to change the value of the column Invoice_Date (new_invoice table) to today's date for Customer ID 10.
5. Determine the profit of each book sold to Jake Lucas, using the actual price the customerpaid (not the book’s regular retail price). Sort the results by order date. If more than onebook was ordered, sort the results by profit amount in descending order. Perform thesearch using the customer name, not the customer number.
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
You may use the Boolean operator to search for data on two separate topics at once. To get the most relevant results, Kevin should utilize which of the following Boolean operators?
You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department
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.
Using php and sql: create a query that will output only the user_id and message for user_id 8
SQL Server Please help answer question 5 Please type out the answer because I cannot read the last answer because the handwriting is not very clear. Thank you.
Employee table: (E_Id,E_name,dept_name,Salary) Write Update query Increase salary by 5000 if salary between 30000 to 35000 Increase salary by 7000 if salary between 35001 to 41000 Increase salary by 9000 if salary between 41001 to 46000
Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133
Using the Winners table from Figure 12-2, write a parameter query that selects only ananimated picture’s Year field.
List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. From MT SQL 10th Edition