Just answer question 5. I included the table for it ESelectfrom Customer:100 %H Results a MessagesCustIDLastNameFirstNameStreetCityStateZipCode HomePhone11GordonShert336 HIl St.LittletonCO80129123-456-7866210Boren642 Crest Ave.Englewood CC80113235-432-5693311StylesLany9825 S. Crest LaneBelevueWA98104495-738-9984412JohnsonSharon1223 Meyer WayFifeWA98222343-959-947313HayesTodd1400 NW 8thLynnwoodWA98036423-333-3345614WelsHomer123 Main S.SeattleWA98105623-474-7343715HllMary206 McCaffreyLittletonCo80129647-757-3734Query executed successfully. 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.

Street is containing the area code. We will use like operator.

Answered: 5. List the name and phone number of…

5. List the name and phone number of the customer with area code of '678'.

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Similar questions

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
State the difference(s) between the Short Table Look up and the Long Table Look up. How do you know which type of table look up you will need?
What should you keep in mind while you blank out rows, columns, and tables?
A table called "game1" contains three columns and twenty rows, but "game2" has the same column as game1 (ie 3) and fifteen rows. Both tables have 5 rows in common. What is the degree and cardinality of the resulting table if we take union?
Consider a scenario where you have a table on the left with 10 rows and a table on the right with 5 rows. What is the maximum number of rows that might appear in a right join
You have the table T = (name, ssn, phone number) representing a person. Each name is uniquely identified by ssn, but the same name can have multiple phone numbers. Suppose you break the tables into two tables T1=(name, ssn) and T2= (name, phone number) a) What are the candidate keys of T, T1, and T2, respectively?
How to do this? I mean formula Create a Vlookup Table for Children. Give it a name and use that to create a new column Size of Family 0 "No Children" 2 or less "Small" 3 or more "Big"