Answer 4 only. I included the table. 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.

4. Answer: SELECT LastName, FirstName, ZipCode FROM Customer WHERE ZipCode IS NULL;

Answered: 4. List all customers (last name, first…

Engineering

Computer Science

4. List all customers (last name, first name and zip code) whose zip code is missing (unknown).

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

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?
Under what circumstances should you not create an index for a table?
Please Type! what is an Isolation property of transactions in SQL (database)
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Also explain why other options are FALSE. Thank you!
Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000…
In what way does SQL differ from other programming languages?
Identify the categories of books that are currently in the stock. Only one instance of each category should be used.
How is possible to start the MySQL console to run? How to update , insert ,select, delete data into table by using some special SQL statements?
what is table ?
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"
How to update in sql